I have a Table called 'TableA'. It has a column called 'ColumnA'. I set up ColumnA to be a ComboBox who's Row Source is a query of another table selecting two columns called 'Column1' and 'Column2'. The Bound Column is 1 (Column1) and the Column Count is 2. Column Widths are 20cm;55cm. List Widths is 10cm.
When I open TableA in Datasheet view, and click in ColumnA and click on the arrow to launch the ComboBox, only Column1 displays. To view Column2 I need to use the scroll bar at which time only column Column2 is visible and I need to scroll back to see column Column1. Adjusting the Column Widths or the List Width does not solve it.
How do I set-up ColumnA so I can view multiple columns in its combobox? I'm assuming its a Field Property in the Lookup tab of Design View of ColumnA. I know its possible because I have another database with a table and column that does this. I compared the Design View Lookup values and they are the same, yet I have this display problem.