Help with Text Box

E

Eric

I have a text box that contains weight (in ounces). When a
user puts in the ounces with a decimal point, it
automatically rounds to the nearest whole number. I have
tried to format the table to include decimals as well as
the form but to no avail. There is also no code behind the
text box. Is there something that I am overlooking?
 
R

Rick Brandt

Eric said:
I have a text box that contains weight (in ounces). When a
user puts in the ounces with a decimal point, it
automatically rounds to the nearest whole number. I have
tried to format the table to include decimals as well as
the form but to no avail. There is also no code behind the
text box. Is there something that I am overlooking?
Click to expand...

Most likely you set the field up as an Integer or Long Integer neither of
which support fractional values. You need to use either Single, Double, or
Currency.
 
Top