I need to display my fields as three place decimals

  • Thread starter Thread starter Dr. Darrell
  • Start date Start date
D

Dr. Darrell

I have a table with two fields; Primary Key (Auto Number) and Size.

The Size fiels will contain a list of sizes.

I have entered:

..023
..030
..035
..045

The following is displayed:

0.000
0.000
0.000
0.000

I need to display:

..023
..030
..035
..045

How should I set my formatting?

Thank you,
Darrell
 
hi Darrell,

Dr. Darrell said:
I have a table with two fields; Primary Key (Auto Number) and Size.
The Size fiels will contain a list of sizes.
Click to expand...
Check the field type, it must be Numeric and not Integer nor Long Integer.


mfG
--> stefan <--
 
Back
Top