Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Friday, June 27, 2008 – Permalink –

Avoid AutoComplete Errors

Don't start


When you type an entry in a ComboBox control Access will attempt to complete the entry based on the control's lookup list. This is controlled by the AutoExpand property, which is set to "Yes" by default.

If your value list contains several items that are close in spelling, it is easy for users to let Access choose the wrong item by accident.

You can avoid errors by setting the control's AutoExpand property to "No" in Design view.

Once the change has been made, users will be forced to type the entire entry or select an item using the ComboBox control's dropdown list.

[Edited entry from 3/3/2005]




See all Topics

Labels:


<Doug Klippert@ 5:42 AM

Comments: Post a Comment

Links to this post:

Create a Link