98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms
Forms
Resolved · Medium Priority · Version 2003
Fri 29 May 2009, 11:31Delegate Adele said...
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.
Mon 1 Jun 2009, 10:02Trainer Stephen said...
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
Mon 8 Jun 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Open A Combo Box AutomaticallyThis is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys. |
