Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prevent Rounding in Forms

Status
Not open for further replies.

ProgEval

MIS
Sep 21, 2006
59
US
I have a form set up to accept a number. Currently it rounds the number automatically (1.5 = 2). I want it to accept a 1.5 or 1.75, etc. I have changed the format to standard and the decimals to "2" in both the table and the form properties, but it is still rounding the entry when it loses focus.

Any ideas on how to prevent it from rounding each entry?

Thanks in advance.
 
Actually, I figured it out. Long integer does not allow for decimals, so I changed it to a double.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top