i have a value list on my Sub form which is set to value list and has a row source of "5.50";"3.05";"6.00";"6.40";"6.80";"6.99";"3.89";"6.99". So the user can select the appropriate extended price.

but the this unit price keeps rounding to the nearest whole pound.
The decimal places is set to 2 so i don't know what the problem is.........

You need to change the field's datatype to Currency (or at least to Single).

Since pricing tends to change over time I would not use a value list as the rowsource.

The format is set to currency and i have an update query which the user can change the prices accordingly. still rounding up though

ok now i have created a query instead of the value list so it updates correctly but other than it keeps rounding up and now the input remains invisible despite the fact visible being set to yes and show- always......the price is still being input as the calculations still occur.

anybody have any clue as to why this is happening?

Where is the datatype set to currency? It must be set to currency on the FIELD'S datatype property (in the table). It should also be set to currency in the CONTROL's datatype property.

it is set to currency in the table and on the subform under Format= currency......it's got me stumped.

ok it is done the limit to list was set to yes..........how annoying.

thnx for the patience.

back to square 1 though:
still roundin up

Edited by: Morbid on 03.14.04.

Attach the db, let's take a look at it.

i'm soo stupid...

was set to long integer in table.....duh!

changed em all to single works fine.......cheers.

i really should take a break


Edited by: Morbid on 03.14.04.

LOL, maybe you should pay closer attention to the advice being offered, or maybe I should have put IN THE TABLE in bold uppercase.

Glad you got it going!