Decimals in number fields automatically rounding (1 Viewer)

browninaz

Registered User.
Local time
Today, 14:17
Joined
Oct 26, 2012
Messages
88
Hello everyone,

I have created a sub form in a form that allows data entry for order details. I have a column that holds order amounts that automatically rounds up or down, and I don't want this. How do I fix this issue? I have examined the back end table properties for this particular field, and the number field is set to general. Is there something I am missing?

Thanks to all who know more than me...
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:17
Joined
Aug 30, 2003
Messages
35,339
What is the data type and field size of the field? My guess is the field size is Integer or Long Integer, neither of which can hold a decimal.
 

browninaz

Registered User.
Local time
Today, 14:17
Joined
Oct 26, 2012
Messages
88
Thanks for the quick response Paul,
The field size is set to Long Integer. What should I set the field size to?
 

browninaz

Registered User.
Local time
Today, 14:17
Joined
Oct 26, 2012
Messages
88
Never mind Paul,
I figured it out. Set to double.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:17
Joined
Aug 30, 2003
Messages
35,339
That should work, as will single and currency.
 

Users who are viewing this thread

Top Bottom