Combo Boxes - No Longer Set

ComboBox NotInList Event: Revisited

We improve our NotInList event code with a workaround for the "text you entered isn't an item in the list" error message via the little-known Form Error event handler.

Combo Boxes

Using the NotInList Event in Microsoft Access to Dynamically Update Combo Boxes

The Microsoft Access combo box's NotInList event lets you provide "just-in-time" features for building a simple and intuitive user experience.

Combo Boxes

Dealing with Inactive Items in a Combo Box Row Source

There are many ways to deal with inactive RowSource items in combo boxes. Here's a no-code technique that I find myself coming back to time and again.

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.

Combo Boxes

ComboBox .Undropdown Method

Combo boxes have a .Dropdown method. But what if you want the opposite: a .CloseDropdown method? This tip from Adam Waller has the answer.

Combo Boxes

A Lazy-Loading Combo Box In Only 3 Lines of Code

Combo boxes that pull down too many records can slow down your Access forms. Boost performance with my class module and 3 lines of code.

Combo Boxes

A Wonderful, Magical Class Module

Imagine a single class module you can use for progressive combo box filtering, lazy loading combo boxes, AND multi-column filtering!

Presentations

Advanced Combo Box Techniques

A list of resources and further reading to support my presentation on Advanced Combo Box Techniques.

Combo Boxes

5 Advanced Combo Box Techniques to Take Your Access Forms to the Next Level

Increase the combo box's "target area," lazy load your data, add progressive filtering (for multiple columns!), and implement dead-simple cascading.

Combo Boxes

Lazy Loading Combo Boxes

Don't load tens of thousands of records into a combo box. Instead, wait for the user to start typing, and then load only what they need.

Combo Boxes

Cascading Combo Boxes

Cascading combo boxes are one of the best ways to find data in a fixed hierarchy. Here's what the concept looks like in action.

Combo Boxes

Multi-Column Progressive Combo Box Filtering

You, too, can learn to filter your combo boxes by every visible column.

Combo Boxes

Progressive Combo Box Filtering

Autocomplete for combo boxes with hundreds of thousands of entries? It's possible with the progressive filtering technique.

Combo Boxes

Combo Box Benefits

An overview of some of the benefits of combo boxes, including autocomplete, hierarchical searching, and auto-updated most frequently used lists.

Combo Boxes

Combo Boxes: Use Responsibly

Comic book legend Stan Lee captured the essence of the Microsoft Access combo box control in six words, "With great power, comes great responsibility."

Combo Boxes

Combo Boxes and Target Sizes

Just like in darts, it's easier to hit a larger target when using the mouse. With this in mind, let's make our combo boxes more user-friendly.

Basic

Combo Box: Behavior Deep Dive

Join me as I take you on an animated gif guided tour of the default behavior of the Microsoft Access combo box, with emphasis on the autocomplete feature.