I am trying to make a field be restricted to a dollar amount where the $ automatically shows up. I am aware that the field must be numeric. I do not want the user to have the ability to override the format. Any result must contain all digits of the value. So it should look like any one of these. $0.55 $5.00 $5.55 $55.00 $55.55 $555.00 $555.55 etc.
I am using FileMaker 7.
Thank you for any help.