On Sun, 30 May 2004 15:45:50 -0700, Turner wrote:

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!

As the control source of an unbound control:
=Format([FieldName],"$ #,###.")

will show the amount with comma separated thousands, rounded up
without any decimals. I've add a space between the $ and the amount
because I like it that way. Remove the space if you don't want it
there.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.