Text boxes rounding entries

[JimS]

I have a text box control formatted as "Standard" numbers with 2 decimal
places. Why oh why is it rounding to no decimal places? Enter 3.5, it rounds
to either 3 or 4 when you press enter!

 

[Douglas J. Steele]

Odds are you forgot to change the field's FieldSize property to either
Single or Double from the default Long Integer.

 

[pietlinden]

I have a text box control formatted as "Standard" numbers with 2 decimal
places. Why oh why is it rounding to no decimal places? Enter 3.5, it rounds
to either 3 or 4 when you press enter!

What's the format of the field in the TABLE? What forms do doesn't
mean jack. I _could_ format my control as a text field if I wanted.
Totally absurd, sure. But that's the point. It will look fine until
you save the record. If the field is some kind of integer (NOT Single,
Double or Decimal), then there's your problem.

 

[JimS]

I was assuming that the database stored numbers with 2 decimals as integers
(used to be that way in the old days...), so I never thought anything about
it. I fixed it and you guys are great! Thanx