Power Tip: Search as you type in an Access form

Today’s Power Tip comes from Brandon with OpenGate Software, offering Microsoft Access products for Access users of every experience level, including UI Builder, Designer, and Dashboard Builder for Microsoft Access.

"Search-as-you-type" has become a pervasive feature of any modern user interface. For example, the major search engines try to predict what you are searching for as you type in the search box. Access does a version of this when you type into a drop-down box; if one of the items in the list begins with the characters you are entering, the list skips down to that item. However, Brandon's solution acts more like a filter, limiting the list to only those items that contain the characters you have entered.

Read the full post on the OpenGate Software site to learn how to add search-as-you-type capability to your own Access forms.

Thanks, Brandon!

--Chris Downs

Got an Access Power Tip you'd like to share? Send it to accpower@microsoft.com.