display format of numbers not working

S

SirPoonga

I have a dropdown box listing floating point numbers. I want the
format to be '0.00'. So if it is less than 1 the leading zero shows
and 2 decimal places alway shows. In the propertied for the dropdown
under the Format tab I set Format to Fixed and Decimal Places to 2.
That should work but it isn;t. the zeros after the decimal are not
showing for the selected item, but they are showing correctly in
dropdown list.

The field in the database the list is coming from is also setup as
Fixes and 2.
 
S

SirPoonga

I will add, it isn't formatting on Page Load. On page load I requery
the dropdown and reset the selected item. When I select an item it
shows it formatted.
 
D

Douglas J. Steele

Assuming the combobox is based on a query, use the Format function in your
query to set the display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top