I have set up a control on a form that reads the results from a query. This query displays multiple rows with three columns. The first column is narrow with 3 or 4 characters in width, but the other two columns have text that can be 35 or 40 characters in width. I want the user to see all three columns properly but when they select a record only the first column will display in the form.

Here is a sample of what the user should see,

1.1 - Correspondence to Client - West Region
1.2 - Correspondence to Client - East Region
2.1 - Correspondence to Vendor - Joe's Shovels
2.2 - Correspondence to Vendor - Jimmy's Excavating
2.3 - Correspondence to Vendor - Tools R us
3.1 - Legal Documents - Permits and Certificates

This data has been set up in tables, and a query was made from these tables.

Any ideas as to how I can do this would be greatly appreciated.

Hi,



You are correct that a combobox can only "display" the value from one of the columns after the selection is made. If you want the user to still see the other columns, you can use additional textboxes to display the value from the other columns by using the Column property. For example, in the Control Source of another textbox, you can use something like:

=[ComboboxName].Column(x)

Where "x" is the column number minus 1. So, if you want to display the second column info, you would use:

=ComboboxName.Column(1)

Just my 2 cents...