Showing multiple fields in 'unopened' Combo Box ??

[Will]

When I use the Wizard to add a combo box it ask me what fields I want to
show.

I select the 3 fields...

idName
Fname
Lname

and tell it to hide idName

When I click on the Combo box I see the First and Last name...

But when it is closed I only see the First Name.

I want to see both the First and Last name when the combo box is closed. How
can I do this?

thanks for any help.

 

[Douglas J. Steele]

You can't: a combo box will only show one field when it's not open.

Your options are to concatenate the fields together in the query that
populates the combobox, or put logic in the combobox's AfterUpdate event to
display the additional columns in text boxes.