The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Combo Box - display

Resolved · Urgent Priority · Version 2003

ReplyFri 22 Jan 2010, 10:31Delegate Heather said...

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

For upcoming training course dates see: Pricing & availability

ReplySun 24 Jan 2010, 14:13Trainer Stephen said...

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

ReplyWed 27 Jan 2010, 11:32Delegate Heather said...

RE: Combo Box - display

Thanks Stephen - that's great.

Regards
Heather

ReplyMon 1 Feb 2010, 13:58Delegate Heather said...

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 articles

· Access VBA Training Adds Power to your Databases
· User-Level Security In Access
· How Do Cross Tabs And Pivot Tables Differ In Microsoft Access?
· The Benefits of Certified Microsoft Training in Access
· How To Use The Analyze Table Tool In Access

Please browse our web site to find out more about
2000 access microsoft training and other Microsoft training courses.

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips