format combo box

[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

 

[Rick Brandt]

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?

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

 

[Chrissy]

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

 

[Rick Brandt]

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?

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.

 

[Chrissy]

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