Solved Format a numeric field with a comma and no decimal point (1 Viewer)

[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

 

[Pat Hartman]

NEVER format data in a table. Users never look at tables. Only the programmer looks a tables and the programmer needs to know EXACTLY what value the field contains. For example, if you have a double precision number and it is 123.49 but you format it to have 0 decimal places, when you open the table and view the data, the value will be 123 but if you were to use criteria in a query to search for 123, you would not find this record.

All formatting belongs in forms and reports. Formatting is for human consumption. You might occasionally have to format in a query if you are exporting the data to Excel or some other app to suit their needs.

 

[access2010]

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

 

[Pat Hartman]

You're welcome