combo box display

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I've got a combo box that displays 3 numerical columns. How do I control
the display of the dropdown columns so the first column is Fixed to 2
decimal places, 2nd is Fixed to 3 decimal places, etc..

TIA,
Fred
 
Use a query as the combo box's RowSource. In the query, set the format for
the desired field by right-clicking on the field and selecting Properties.
You can set the format there.
 
I've tried that and it doesn't seem to take. I'll change the format in the
query via the method you suggested and when I try it out nothing changes.
When I go back to see the formatting in the query it goes back to being
blank as if nothing was changed in the first place.

Fred
 
Not sure why that isn't working for you, but the alternative way is to use a
calculated field in place of the original field, and use the Format function
in the calculated field to set the format of the original field.
 
Thanks Ken

Ken Snell said:
Not sure why that isn't working for you, but the alternative way is to use a
calculated field in place of the original field, and use the Format function
in the calculated field to set the format of the original field.
Click to expand...
 
Back
Top