Number format in listbox

[paul]

Hi

Im trying to set the number formats in a listbox to "Standard" with no
decimal places.

Currently i can get it to display by:

5,000,000.00

by using: format([area_sqft],'Standard') in the query for the
rowsource of the listbox, however i can't get it to remove the 2
decimal places.

Any ideas?

Thanks
Paul

 

[Douglas J. Steele]

Format([area_sqft], "#,###")