combo box display

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Combo Box - display

Combo Box - display

resolvedResolved · 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

Thanks Stephen - that's great.

Regards
Heather

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


 

Access tip:

Pop up property

If 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.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips


Server loaded in 0.08 secs.