One field that displays text and currency
FMP 10 on MAC
Is there a way I can have one field that accepts both text and numbers but when numbers are entered the field automatically adds a "$" before the number and forces two decimal points? I can make the field a number field and take care of this by using formatting but then the field will not display any text that is entered into the field. Does this make sense? Any help is greatly appreciated. Thanks!