decimal points

  • Thread starter Thread starter blendes
  • Start date Start date
B

blendes

My problem is that i have to fields in my databse that will hold values like
..240. needs to hold all three decimal places including 0. I can not get the
field to show the value when it prints. In the datasheet it holds the correct
vuale but the form displays only .24.
 
Neither leading nor trailing zeros are saved in numeric data. If the value
is .24, that is all that is stored. It is up to you to format the values
when you want to present them to the user. If forms and reports you can use
the Format property of the control in which they will be presented to make is
display as .240. In queries or VBA you use the Format function. For
example, if you want a value to always show 3 decimal positions, it would be
Format(MyNumber, "#.000")
 
thanks for the help.

Klatuu said:
Neither leading nor trailing zeros are saved in numeric data. If the value
is .24, that is all that is stored. It is up to you to format the values
when you want to present them to the user. If forms and reports you can use
the Format property of the control in which they will be presented to make is
display as .240. In queries or VBA you use the Format function. For
example, if you want a value to always show 3 decimal positions, it would be
Format(MyNumber, "#.000")
Click to expand...
 
Back
Top