Combo Box, show multiple columns

M

Melissa

I have a combo box that references a list of 4 columns. I have the column
width property in the combo box set up as 50pt, 0pt, 0pt, 100pt so the list
shows the first and second columns of my list.

When I choose an option in the list I see the data in columns 1 & 4 like I
want:

Ex: 1234 Joe Smith

However after I select the person I only see the 1234 in the combo box
itself, how can I show both 1234 and Joe Smith after they have been selected?
 
S

ShaneDevenshire

Hi,

I'm not clear on this one, you have your columns set to 50, 0, 0, 100 and
then you say you see columns 1 and 2? I would expect to see 1 and 4.

You might try a concatenated single column display. For example the list
would display one column =Column1 & " - " & Column4
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Combo box 0
Combo or list box 0
Combo box 2
How to join row data into one row 1
Flattening Data 2
Adding Problem 6
Need some PWA help 0

Top