Format mask...

[mrDrive]

Hi All:
I'm working in Dev 6. I am trying to format the contents of a text box in forms to display a number field like $99,999.99. Under the properties pallete for the text element have have these settings:

Data Type: Money (tried Number too)
Maximum Length: 30 (plenty big)
Fixed Length: No
Format Mask: FM"$9,999.99"

The datatype from my table is defined 'number (7,2)'.

The text element is long enough, but everytime I run the form the values show up ##########.

Any help would be very much appreciated!

 

[malleykr]

Try setting your format mask to $99,999.00

I'm not sure about forms6, but in forms 4.5 including the quotes around the format mask changed all the data to #########. Try leaving them off.

Also, make sure to have five 9's before the decimal (instead of the four indicated in your post). A number(7,2) has five digits to the left of the decimal and two after it. The 0's after the decimal in the format mask will ensure that there are always 2 digits following the decimal. Otherwise you might end up with $100 instead of $100.00.

Good luck!

 

[mrDrive]

Thanks a bunch Malley! That did the trick. Man, they can be quirky sometimes