Forms - No Longer Set

Understanding the Access ColumnWidth VBA Property

The ColumnWidth property of an Access datasheet has some strange behavior, especially when it comes to its special values: Default Width and Size to Fit.

Quick Tip

Quick Tip: 4 Ways to Select the Bottom Control in a Stack

There are many situations that call for two (or more) controls to be stacked on top of each other. In those situations, how does one select the bottom control?

Forms

The Reason MS Access Forms and Reports are Limited to 22 Inches

With today's large monitors, many Access developers have bumped into the 22" maximum form width. But do you know why it's not 21" or 23"?

Forms

7 Ways to Loop Through Controls on a Microsoft Access Form

There are many ways to use VBA to hide/show or lock/unlock groups of controls on an Access form. Here are seven different techniques you can use.

Forms

6 Techniques to Control Where Forms Open On-Screen in Access

With Overlapping Windows in Access, you need to think about where each form should open on-screen for the user. Here are 6 techniques to help you do that.

Combo Boxes

How to Add a Catch-all Value to a Combo Box in Access

Two ways to let your users choose "All of the above" when using your combo boxes.

Forms

AutoFitDatasheet: A Function to Prettify Your Access Datasheets

This routine resizes the columns of the active datasheet window (plus the window itself) based on its contents to make the best use of the available space.

Forms

2 Ways to Escape Leading Quotes when Adding Items to a List Box

Leading quotation marks can cause problems when adding items to a list box or combo box. Here are 2 easy ways to deal with the issue.

Forms

Escaping Semicolons in a Multi-Column Access ListBox

When adding items to a multi-column list box, the semicolon character is used to separate columns. What if the items themselves contain semicolons?

Forms

Lazy Loading a Tabbed Form in Microsoft Access

How to use "just-in-time population" to dramatically decrease the load times of complex Access forms.