Rounding Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the setup...I have a text box on a form that is bound to a field in a
table. When users enter a number into this text box, I want it to be
displayed to 2 decimal places. So in the table, it is set to Double. On the
form, the text box has an Input Mask of 99.99. When I enter a value into the
text box, such as "12.25", it rounds and displays "12.30". In the table, it
is accurately displayed as "12.25". How do I get it to show the same on the
form?
 
Nothing in what you have described would cause the displayed number to be
rounded. Check the "format" property of the control on your form.

Damian.
 
The format property is blank. I'm at a loss.

Damian S said:
Nothing in what you have described would cause the displayed number to be
rounded. Check the "format" property of the control on your form.

Damian.
Click to expand...
 
Right now there are 4 text boxes I am having this problem with. On 2 of
them, I simply widened the box and the rounding problem quit. It didn't work
for the other 2, so I'm still working on those.
 
Back
Top