Solved Format a numeric field with a comma and no decimal point

[access2010]

Could I please receive a suggestion on how to format a number with a comma for thousands and having no decimal?

10000 should be displayed as 10,000 (never with any decimal place)

We are using MsAccess 2003.

Thank you.
Crystal

 

[CJ_London]

use the format property for the control. for no decimal places use #,##0

 

[Ranman256]

format STANDARD,
decimals = 0
for field, or textbox

 

[access2010]

use the format property for the control. for no decimal places use #,##0

Thank you for pointing me in the right direction, to control the formatting on the form and not at the table.

Crystal

 

[access2010]

format STANDARD,
decimals = 0
for field, or textbox

Thank you for pointing me in the right direction, to control the formatting on the form and not at the table.

Crystal

 

[access2010]

Thank you Pat Hartman.
I have made a note of your suggestion to be used in our future forms.
Thank you.
Crystal