Forms - No Longer Set

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.