98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Combo Box - display
Combo Box - display
Resolved · Urgent Priority · Version 2003
Heather has attended:
Access Intermediate course
Access Advanced course
Excel Advanced course
Access Advanced course
Combo Box - display
Can someone please remind me how I display multiple columns in a combo box. For instance if I have a combox box with colums Fee Earner and Fees how to I make it display both of these and not just the name of the fee earner.
Grateful for some help here - I know it's really simple - just can't remember.
Thanks
RE: Combo Box - display
Hi Heather
Thanks for your question
Open the form in design view and select the combo box in question.
Click on the properties button on the main toolbar, and select the format tab on the resulting properties sheet.
The third option down should be the column count property. set this to whatever number you require.
Note you can also specify the width of each column in the column widths property. For example 3cm;2cm would set a 2 column combo box with first column at 3cms and thesecond at 2.
Hope this helps
Regards
Stephen
RE: Combo Box - display
Unfortunately the solution has not worked and although I can see both columns when I drop down the box it only displays the first (bound) column. When I attended the Advanced course I remember that the trainer did something else in order to make this work but I can't remember what the something else was.
Any further help here would be great.
Regards
Heather
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:Pop up propertyIf you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On. |