Number format in listbox

  • Thread starter Thread starter paul
  • Start date Start date
P

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
 
Back
Top