 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Form Rounds up Decimal numbers, WHY?
I have two number fields. In the table I have the fields set up as decimal and the format is general number with two decimal places. I have the same format for the fields in the form, but everytime I try to put in a decimal number the form automaticaly rounds it up to the nearest whole numer. Any idea why?? When I see that kind of behavior, I look for formatting as an Integer or Long Integer. If you don't find it in the underlying table or in the form, and you don't have code running behind the form that might do that, consider re-creating the form. Sometimes an Access form can get subtly corrupted and (I've found) it's easier to start over. Regards Jeff Boyce Microsoft Office/Access MVP >I have two number fields. In the table I have the fields set up as decimal > and the format is general number with two decimal places. I have the same > format for the fields in the form, but everytime I try to put in a decimal > number the form automaticaly rounds it up to the nearest whole numer. Any > idea why?? I have tried all possible formats, and recreating the form at this point happens to be extremely inconvinient and time consuming. It has way to much stuff on it. thanks for the suggestion though. >When I see that kind of behavior, I look for formatting as an Integer or >Long Integer. [quoted text clipped - 14 lines] >> number the form automaticaly rounds it up to the nearest whole numer. Any >> idea why?? >I have tried all possible formats, and recreating the form at this point >happens to be extremely inconvinient and time consuming. It has way to much >stuff on it. Just to clarify - the problem is probably not the Format of the number, but the Datatype. The default Number datatype in a table is long Integer - and integers are, by definition, whole numbers. Check the table definition! You should not need to recreate the form if you change the datatype of the underlying field. John W. Vinson [MVP] "In the table I have the fields set up as decimal and the format is general number with two decimal places" would indicate that you have the datatype set as *decimal.* Unless this datatype has been added since AC2000 (it doesn't exist in 2000), John has to be correct!  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 > "In the table I have the fields set up as decimal and the > format is general number with two decimal places" would > indicate that you have the datatype set as *decimal.* Unless > this datatype has been added since AC2000 (it doesn't exist in > 2000), John has to be correct! Decimal exists in Access 2002, but it stores only integers. One must set the Scale property to the correct number of decimal places, the decimal places property is useless. SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com "missinglinq via AccessMonster.com" <u28780@uwe> wrote in message <7523f574c2736@uwe>: > Unless this datatype has been added > since AC2000 (it doesn't exist in 2000), John has to be correct! Hm, are you sure? Data Type: Numeric Field Size: Decimal SignatureRoy-Vidar |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.