forms
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Forms

Forms

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

resolvedResolved · Medium Priority · Version 2003

No ranking yet
5 posts
replyReplyFri 29 May 2009, 11:31Delegate Adele said...

Adele has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Forms

Hi,

I have a combi box with 3 columns, and I want those three columns to all display when one record as been selected/highlighted. At the moment, as soon as one record is selected, only the first column displays. How do I ensure that all three columns continue to display on the form for the selected row?

Many Thanks,
Adele.

Access VBA 2 day course
Version Date Location Places
available
Book Next place rate (£)
Pay by
Card
Pay by
Invoice
2003 Wed 24 + Thu 25 Mar 2010 Southwark 8 Book now £445 £450
2003 Wed 5 + Thu 6 May 2010 Bloomsbury 10 Book now £275 £280
2003 Mon 28 + Tue 29 Jun 2010 Bloomsbury 10 Book now £275 £280
2003 Wed 4 + Thu 5 Aug 2010 Bloomsbury 10 Book now £275 £280
2003 Thu 9 + Fri 10 Sep 2010 Bloomsbury 10 Book now £275 £280
2003 Wed 27 + Thu 28 Oct 2010 Bloomsbury 10 Book now £275 £280
Full Schedule: See all 7 Access VBA course dates.
Bookings currently available until 6th December 2010.

Platinum
753 posts
replyReplyMon 1 Jun 2009, 10:02Trainer Stephen said...

RE: Forms

Hi Adele

Thank you for your question.

The solution is fairly straightforward. You need to set the column count property of the combo box to 3. This will then display 3 columns.

To locate this property, select the combo box in design view, bring up your property sheet and select the data tab. Alternatively you can do it in code with

me.combobox.columncount = 3

You can also set the column heads property to true, and this will display the field name at the top. Finally you can also set the column widths property, for example:-

"3cm;2cm;4cm"

set the above widths to the three columns

Hope this helps

Regards

Stephen

Mon 8 Jun 2009: Automatically marked as resolved.


Related articles

· When Is Microsoft Access Not The Best Choice For Your Business?
· Data validation in MS Access
· How Reorganising Your Data Can Take Your Business to the Next Level
· Some Simple Database Questions Answered
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

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

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips


Rate this page:
2.1/5 (108 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard