combo box display

[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

 

[Ken Snell [MVP]]

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.

 

[Fred]

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

 

[Ken Snell [MVP]]

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.

 

[Fred]

Thanks Ken

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.