Currency field rounding up

  • Thread starter Thread starter KarlHardeman
  • Start date Start date
K

KarlHardeman

I have a field that is populated by using a drop down combo box. This
figures are being rounded up/down depending on how near they are to the whole
number. I have tried changing the field to double, but this still doesn't
work. Would any of you kind people have any other idea's I might try.
 
Currency fields will that as they are normally (if from a formula) based on
other currency fields.

Currency
1.234 = 1.234 2.47

Number
1.234 = 1.234 2.468

What does this mean - can you give more details
I have a field that is populated by using a drop down combo box.
Click to expand...
 
Sorry - typeing error - should have been

Currency
1.234 + 1.234 = 2.47

Number
1.234 + 1.234 = 2.468
 
Hi Wayne

This field is NOT based on any formula's or calculations. A curreny field
with a value for example £73.48 is chosen from a Combo box and is displayed
at £73.00's

Many thanks
Karl Hardeman
 
KarlHardeman said:
I have a field that is populated by using a drop down combo box. This
figures are being rounded up/down depending on how near they are to the
whole
number. I have tried changing the field to double, but this still doesn't
work. Would any of you kind people have any other idea's I might try.
Click to expand...
 
On Thu, 16 Jul 2009 00:13:01 -0700, KarlHardeman

Open the table in design view.
Select the field to which this combo is bound.
What is its Datatype (the second column in the query grid)?
If the datatype is Number, what is the size (the first row in the field
properties box on the lower left)?

My guess is that the datatype is Number and the size is Long Integer. Integers
are by definition whole numbers. If this is the case change the datatype from
Number to Currency, and you should be back in business. You may need to update
existing data.
 
Hi John
Thanks for your reply. It was set to number and long interger and I have
now changed this. Unfortunately this hasn't worked creating a new record.
Do you have any further idea's?. The one thing it did say, is that it
wouldn't allow me to save those changes as it was a linked table, but gave me
the option to save anyway. Would this have any affect? Your thoughts and
comments appreciated.
Many thanks
Karl Hardeman
 
You have to make the change in the source table in the source database.
Making it on the link has no effect on the data type or number type.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Thanks for your reply. It was set to number and long interger and I have
now changed this. Unfortunately this hasn't worked creating a new record.
Do you have any further idea's?. The one thing it did say, is that it
wouldn't allow me to save those changes as it was a linked table, but gave me
the option to save anyway. Would this have any affect? Your thoughts and
comments appreciated.
Click to expand...

If it's a linked table you must change the datatype in the backend. The table
that you see isn't really the table; it's just a link to the table, and you
cannot change field properties there.

Open the backend, make the change there; open the frontend, DELETE THE LINK
(delete the table icon), and use File... Get External Data... Link to relink
to it.
 
Back
Top