Book

Suggestions


Enter your email address:

Delivered by FeedBurner



Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












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



  Saturday, August 08, 2009 – Permalink –

Reduce Entry Mistakes

Disable AutoExpand


When you type an entry in a combobox control Access will typically attempt to complete the entry based on the control's lookup list.

This is controlled by the AutoExpand property, which is set to Yes (-1) by default.

Although such behavior is helpful, it can cause problems if your value list contains several items that are close in spelling, since it's easy for users to accidentally let Access choose the wrong item.

You can avoid errors by setting the control's AutoExpand property to No (0) in Design view or using VBA to set the property equal to 0.

Once you've made the change users are forced to type the entire entry or select an item using the combobox control's dropdown list.

(Works the same in Access 2007)






See all Topics

Labels: , ,


<Doug Klippert@ 3:06 AM

Comments: Post a Comment