My Lookup lists are loosing decimal places!

[nicktheblue]

Hello fellow members,
This is my first post so please be gentle!
My problem is, as the title suggests, that my lookup lists are not displaying the correct number of decimal places for currency. I have set the properties in the table the list is taken from to 4, I have created a query for the list and set that to 4 (which displays as 4 in the query), I have changed the windows settings to 4, but I still only get 2 decimal places. Somebody must know the answer, and it is no doubt quite straight-forward, but it is driving me to despair - please help!

 

[pcs]

in the QBE grid of your list query, right click on the desired field column. select: properties. set the properties to something like:

Format: #.####
Decimal Places: 4

was that gentle enough?

hth,
al

 

[Carol]

Might be wrong, but list boxes are funny, and I think that you have to format the row source for your query within the properties of the actual list box, i.e.:

SELECT Format([Query1].[Cost],"$0.0000") FROM Query1;

This will get you currency values with 4 decimal places.

 

[pcs]

either method should work...but as carol points out , if you want to display the value as currency, and you are using the QBE grid, change the properties to:

Format: $.0000 or $0.0000 (depending on whether you want display a leading zero)

Decimal Places: 4

al