Rounding Problem

[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?

 

[Guest]

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.

 

[Guest]

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

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.

 

[Guest]

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.