Listbox number format

[ctaylor]

I have a listbox which has a field bound to a table.

The values in the table are recorded with 4 digit precision, the values in the listbox are displayed with only 2 digit precision.

How do I get the listbox to display 4 digit precision numbers?

 

[D-Fresh]

You should set the format to display four decimal places in the SQL statemnt in your rowsource. Go to the SQL builder in the row source field of the properties sheet. In the field that you're looking for the decimals put this as the field Name..

NewNumber: format([OldNumber],"#.0000")

NewNumber will be the newly formatted detail and OldNumber is the old field that only displayed to two decimals. Hope this helps.

Doug

 

[ctaylor]

Thanks!

This is EXACTLY what I was looking for!