If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form 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?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200707/1 |
#2
|
|||
|
|||
Form Rounds up Decimal numbers, 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 "injanib via AccessMonster.com" u35551@uwe wrote in message news:751d21254e0df@uwe... 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?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200707/1 |
#3
|
|||
|
|||
Form Rounds up Decimal numbers, 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. Jeff Boyce wrote: 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?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200707/1 |
#4
|
|||
|
|||
Form Rounds up Decimal numbers, WHY?
On Fri, 13 Jul 2007 19:42:27 GMT, "injanib via AccessMonster.com" u35551@uwe
wrote: 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] |
#5
|
|||
|
|||
Form Rounds up Decimal numbers, WHY?
"missinglinq via AccessMonster.com" u28780@uwe wrote in
news:7523f574c2736@uwe: "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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com |
#6
|
|||
|
|||
Form Rounds up Decimal numbers, WHY?
"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! -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200707/1 |
#7
|
|||
|
|||
Form Rounds up Decimal numbers, WHY?
"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 -- Roy-Vidar |
#8
|
|||
|
|||
Access and Rounding
To store a number like 1.7 and stop Access from rounding it to 2 set: Field Size - Decimal, Format - Fixed, Presision - ("Number you will store each side of the decimal. I needed 6."), Scale - ("Number of digits you will store to the right of the decimal. I needed 1."), Decimal Places - ("Number of digits displayed. I needed 1."). I know these kinds of things drive you crazy. Me too. Hack it up and take a break sometime. Dave
injanib via AccessMonster.com wrote: Form Rounds up Decimal numbers, WHY? 13-Jul-07 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 Previous Posts In This Thread: On Friday, July 13, 2007 10:12 AM injanib via AccessMonster.com wrote: Form 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 On Friday, July 13, 2007 10:27 AM Jeff Boyce wrote: When I see that kind of behavior, I look for formatting as an Integer or Long When I see that kind of behavior, I look for formatting as an Integer or Long Integer. If you do not find it in the underlying table or in the form, and you do not have code running behind the form t On Friday, July 13, 2007 3:42 PM injanib via AccessMonster.com wrote: I have tried all possible formats, and recreating the form at this 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. Je On Friday, July 13, 2007 9:21 PM John W. Vinson wrote: Form Rounds up Decimal numbers, WHY? wrote: 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 numbe On Friday, July 13, 2007 10:41 PM Bob Quintal wrote: "missinglinq via AccessMonster. "missinglinq via AccessMonster.com" u28780@uwe wrote in Decimal exists in Access 2002, but it stores only integers. One must set the Scale property to the correct number of decimal places, the dec On Friday, July 13, 2007 11:14 PM missinglinq via AccessMonster.com wrote: "In the table I have the fields set up as decimal and the format is "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 ad On Saturday, July 14, 2007 1:09 PM RoyVidar wrote: "missinglinq via AccessMonster. 7523f574c2736@uwe: Hm, are you sure? Data Type: Numeric Field Size: Decimal -- Roy-Vidar EggHeadCafe - Software Developer Portal of Choice Document Compatibility in Internet Explorer 8 http://www.eggheadcafe.com/tutorials...bility-in.aspx |
Thread Tools | |
Display Modes | |
|
|