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 VBA Training and help » Access VBA

	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:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Access VBA

Resolved · Low Priority · Version 2003

ReplyFri 23 Oct 2009, 16:06Delegate Fabian said...

Access VBA

list box - when it gets populated - is it going to change the size automatically so it fits the records or do I need to cater for that and code it?

For upcoming training course dates see: Pricing & availability

ReplyMon 26 Oct 2009, 08:57Trainer Stephen said...

RE: access VBA

Hi Fabian

Thank you for your question

The best approach is to use code to set the column widths for your combo box. Use the column widths property to set this. For example the following would set the widths of a two column combo box.

cmbCombo.ColumWidths = "3cm;5cm"

Hope this helps

Regards

Stephen

ReplyMon 26 Oct 2009, 16:13Delegate Fabian said...

RE: access VBA

ok - thanks for this Stephen

Access articles

· How To Resolve Access Data That Gives You Déjà Vu
· A Greater Understanding Of Your Business With Access Reports
· Microsoft Access as a Business's Database Management System
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database
· It Is Important To Take Care Over Primary Key Assignment

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

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips

How do you get a legible A4 print off of a timeplan?