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

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

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

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]

"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

"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

"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

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