Validating Currency Fields

[JDcruiser33]

Hello All,

I'm fairly new to FM. Have a question: Is there any way to validate a currency field so if the user makes a mistake and types two decimals fields i.e., one for the comma and one for the cents...have some error that just says "invalid format" or something?

Also, same thing with commas. The field is already a currency field with two commas..so some extra validation is what I'm looking for.

Thanks

[comment]

You could validate for numeric-only entry. Your users shouldn't be bothering with formatting at all - they should enter the number and the field should be formatted to display the entry as currency.

[JDcruiser33]

Thanks for the reply. I realized though I wasn't too clear on my original post.

When users are entering data...for example, and want to type in "1,500.25", and they accidently type in "1.500.25", filemaker accepts this but changes it to: "1.50".

Instead of FM accepting and changing the data, can it see that it was an erroneous data entry and just pop up an error?

The field is already numeric and is set to two decimals.

I'm assuming it is going to require some calculation validation? But if there is a more simple way, that would be better.

Thanks again. Hopefully I was a bit more clear.

[comment]

Instead of FM accepting and changing the data, can it see that it was an erroneous data entry and just pop up an error?

Yes, if you set validation to 'Strict data type: Numeric Only'.

[JDcruiser33]

Well crap. That works...sorry for such the lame question. I thought I had everything set where it needed to be. Thank you lots.

Edited May 13, 2008 by Guest