data type question

[Nadalia]

One of my data fileds in the database is called "number of items", so I set the data type as number (filed size - Long Integer). But the problem is that when the number exceeds 1000, my user would like to have a comma in between the number, so that it would be much easier for them to read larger number. For example, if number of items is 2600, they would like the data type to be shown as 2,600 instead of 2600.

How to tell Access to choose appropriate format?

Any idea will be appreciated!

Nadalia

 

[mdemarte]

Under Format, select Standard instead of General.

 

[Nadalia]

thanks! Got it!