How do you change the number format

[PaulJL]

At the moment i can only get the number to display in without formating

For example "123456.78" but i want to be able to show the number with a comma seperating the thousands "123,456,789.10" on the number format display i can see currency and scientific and others but no number format options like is available in excel.

How do i do this, am i missing an add-in for access?

Regards

PaulJL

 

[Parra]

In the format option choose Standard.

 

[PaulJL]

thanks