Controls Archives - Extra Mile Data

Get a list of form controls sorted by tab order

by Carl Connett | Jan 29, 2014 | Arrays, Collections, Controls, Forms, Loops, Microsoft Access, VBA

When you iterate through a collection of controls in a Microsoft Access form, the order of the list of controls that you end up with may not be sorted as you expect. Rather than being sorted by the tab index, the list will be sorted...

Scroll in a Microsoft Access text box using the mouse wheel

by Carl Connett | Jan 27, 2014 | Controls, Forms, Microsoft Access, VBA, Windows API

Microsoft Access does not have built-in mouse wheel scrolling in form text boxes. You can provide mouse wheel scrolling by writing some VBA code in the Form_MouseWheel() event procedure. Trying to scroll in a text box can be particularly frustrating if the bottom of...

Notes

Some operating systems block files that come from other computers. If you cannot get a downloaded file to work properly, right-click over the file, select the Properties option, and then click the Unblock button at the bottom of the General tab.

Get a list of form controls sorted by tab order

Scroll in a Microsoft Access text box using the mouse wheel

Notes

Categories