Adele has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Forms
Hi,
I have a combi box with 3 columns, and I want those three columns to all display when one record as been selected/highlighted. At the moment, as soon as one record is selected, only the first column displays. How do I ensure that all three columns continue to display on the form for the selected row?
Many Thanks,
Adele.
RE: Forms
Hi Adele
Thank you for your question.
The solution is fairly straightforward. You need to set the column count property of the combo box to 3. This will then display 3 columns.
To locate this property, select the combo box in design view, bring up your property sheet and select the data tab. Alternatively you can do it in code with
me.combobox.columncount = 3You can also set the column heads property to true, and this will display the field name at the top. Finally you can also set the column widths property, for example:-
"3cm;2cm;4cm"
set the above widths to the three columns
Hope this helps
Regards
Stephen
