Base the listbox on a query, and do the rounding in the query.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Turner" wrote in message
...
How do you get a list box to display a Currency control
without the cents. I want it to round up to the nearest
dollar.

thanks!