List Boxes

[Turner]

I have several currency type fields within a query. I
have set the "decimal places" property to zero. When I
execute the query it shows the amounts correctly (ie. $,
and no pennies.

When I use the same query as a row source for a LIST BOX
the pennies are diplayed.

How to I get rid of the pennies.

Thanks!

Note: An early answer suggested that I modify the format
field of an Unbound Control with =Format([FieldName],"$
#,###."). But, unless I am really missing something LIST
BOXES don't have control fields.

 

[Damon Heron]

Make the row source of the listbox your query, and have the query read
something like this:

SELECT Currency.CrrID, CCur(Format(Currency.Currency,"$#,###.")) AS
myWholeNum
FROM [Currency];

replacing your table fieldnames as needed. This rounds up your dollar
amounts, however, and still shows $141.00 (two trailing zeroes), so this may
not be exactly what you want...

HTH
Damon