Displaying a large number with commas

[RSfromCO]

I have a view-only field on an MS-Access form that displays a large number. I would like the number to display with comma separators....

10,050,075 rather than 10050075.

Is there an easy way to accomplish this?

 

[PHV]

Have a look at Format.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kvest]

RSFromCO,
On the bound box on the form, click properties, then format. There are several already defined, but if you want commas then use #,###. If you need a $, put that in the front of the 1st #.