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

access vba

ResolvedVersion 2003

Fabian has attended:
Access VBA course

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?

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

RE: access VBA

ok - thanks for this Stephen

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.