Combo Box - display

The UK's most regular instructor-led training courses.
Training information: 2000 access microsoft training · Courses in microsoft access · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Urgent Priority · Version 2003

9 posts

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

Heather has attended:
Access Intermediate course
Access Advanced course
Excel 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

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

748 posts

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

9 posts

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

RE: Combo Box - display

Thanks Stephen - that's great.

Regards
Heather

9 posts

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

· Reasons to Consider Microsoft Access Training
· Microsoft Access and Customer Surveys
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Supersizing your databases via Microsoft Access
· Why consider Access Visual Basic training?

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

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips