Unless, I am totally missing something List Boxes don't
have Unbound Controls. So there's no Format property to
place the formating controls.

So, my question still stands.


-----Original Message-----
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.
.