format combo box

  • Thread starter Thread starter Chrissy
  • Start date Start date
C

Chrissy

I would appreciate your help.

I would like to know how to format a combo box's drop
down list, not just the displayed data.

When I format the combo box, the data, once selected, is
displayed correctly in the box. But when I go to select
another record, the drop down list does not carry the
format.

Can anyone show me the way?

Thanks,
Chrissy
 
Chrissy said:
I would appreciate your help.

I would like to know how to format a combo box's drop
down list, not just the displayed data.

When I format the combo box, the data, once selected, is
displayed correctly in the box. But when I go to select
another record, the drop down list does not carry the
format.

Can anyone show me the way?
Click to expand...

You need to apply the formatting to the query used to populate the list.
 
Thanks Rick.

That takes care of the list OK, but now it gives an error
that the value entered isn't valid.

Can you help again?

Thanks,
Chrissy
 
Chrissy said:
Thanks Rick.

That takes care of the list OK, but now it gives an error
that the value entered isn't valid.

Can you help again?
Click to expand...

Have multiple columns in the query and ComboBox. One that is formatted and one that
isn't. Display the one that is formatted, but use the unformatted one as the bound
column.
 
Thanks! Its working. I don't know how you guys think up
this stuff, but I surely am grateful to have you here.

Thanks again,
Chrissy
 
Back
Top