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.