Help with Text Box

  • Thread starter Thread starter Eric
  • Start date Start date
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?
 
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.
 
Back
Top