change number format by value list

[lastpass]

Hi all!

How can I change the fields format by choosing a value from a list?

I want to use it to change between dollar ($) and euro (€) and this value should valid all number format in the record.

I can't find any describe in help and forum maybe I have to creat a new layout but change the format is more simplier.

[Lee Smith]

See if this Thread helps. Link

[lastpass]

I don't want to calculate currency just change the number format.

Example one record's filed format is in euro an other is in dollar.

[comment]

Unfortunately, the number format of a field is static and cannot be calculated. Some workarounds:

1. Place two instances of the field on the layout inside an invisible tab control; use a script triggered OnRecordLoad to select the appropriate tab;

2. Place the currency symbol outside the field - either as a calculation field, or use conditional formatting to hide one of symbols.

[lastpass]

Thanks I chose the 2nd solution and works fine.