Bookmark page
Printable version
Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms
|
|
|
Bookmark this page|
The UK's most regular 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. |
Forms
Resolved · Medium Priority · Version 2003
Reply
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.
For upcoming training course dates see: Pricing & availability
RE: Forms
Hi AdeleThank 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.
|
 |
|
» Forum post: Database creation |
Is there a limit to the number of reports, queries and forms created in one database?
