decimal numbers in list box...

[Miranda]

hi, i've got a text box that displays a whole heap of stuff including some
decimal numbers. the values are pulled from a table where the field is set
as having decimal number type and with only 1 decimal place...the numbers
are displayed correctly in my table..however when they are displayed in the
listbox on my form they have two decimal places. does anyone know how to set
it so the listbox shows only 1 decimal place for the number fields???

Thanks!!
miranda

 

[Allen Browne]

Use a query as the RowSource for your listbox.

In the query, use Format() to specify how the field should look.

Example:
ShowMyField: Format([MyField], "#,##0.0")