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
