Problem with comma in numeric field

[anders_t]

Hi,

In a portal I have a numeric field where the user inserts a value ("Price per piece"), usually something like 1,30. In the Invoice it will turn out as 13,00 (not what I want!).

If the value is inserted as 1.3 it turns out the way I want it to in the Invoice, ie 1,30. Obviously I want the user to be able to insert the value with a comma and not a dot.

Any help/suggestions are appreciated

Anders

[comment]

Set your file to always use current system settings (in File > File Options... > Text). Tell your user to set his/her OS number format to use comma as the decimal separator.

Alternatively, you could clone the file on a system set to use decimal comma (assuming the original was created under different settings), and set the clone to always use file's saved settings.

[anders_t]

Wow, thanks, it works - when I'm using FMP 8! Unfortunately the users working with this database are still stuck with FMP 5.5 - any way of reproducing this setting under 5.5? There doesn't seem to be any way of setting the file to use current system settings under 5.5... or is there?!

thanks

Anders

[comment]

I am not sure about 5.5, but if it's similar to version 4, then you should have a 'Use System Formats' option under the Format menu. There's also a 'Set Use System Formats' script step that you can include in your opening script.

In any case, cloning the file should work the same. I'd suggest you read the help on opening files with foreign system formats.

[anders_t]

Thank you! That did it! Somehow I had managed to miss that one!

Anders