Help with Text Box

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

 

[Rick Brandt]

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?

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.