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!