Formatting problem with numbers in query

[snowbdr]

I have a list box that is displaying the results of a query. There is
a calculation in the query that ends up with seven or eight digit
numbers. I would like these to be formatted with comma separators but
I want these to be whole numbers without a decimal.

I used the format control and set the number of decimal places to zero.
When I look at the result in datasheet view it looks perfect.
However, when I run the form it still shows the numbers with two
decimal places. I have tried to create an input mask and it does not
change anything. Are there any suggestions?

Thanks in advance!

Johnny

 

[Guest]

You have to format it everywhere you want to display it.