Dear Microsoft Access Tips subscriber,



Here's another useful Microsoft Access tip from Element K

Journals, your number one source for software tips and

techniques.



PLEASE VISIT OUR SPONSOR

***********************************************************

If a picture's worth a thousand words, what are your Excel

charts saying?

***********************************************************



NEW! Microsoft Excel Survival Guide: Smart Charting -

From Simple To Sophisticated



Now available for only $7.95*!



Excel doesn't always make it easy to chart complex worksheet

data. The next time you need to create a custom chart, refer to

this NEW survival guide for insider tips and step-by-step

instructions to successful, pain-free charting.



Order your survival guide today and get FREE shipping**!

To order now or to learn more, go to:

http://www.elementkjournals.com/buy/showPromo.asp?coupon=115808



*International orders $15.90

**Free shipping applies to U.S. residents only



********** THE TIP **********



Avoid entry mistakes by disabling AutoExpand (Access 2000/2002/2003)



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 Auto Expand 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 Auto Expand property to No

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.



Click here to email this tip to a friend, and you'll both get an online

coupon to save 20% off all items purchased at www.elementkjournals.com.



PLEASE VISIT OUR SPONSOR

*****************************************************

Your weekly tips - now available on a searchable CD

*****************************************************



Wish you had access to all the great tips you've received from

Element K Journals when you need them, where you need them?

Now you can!



All of your favorite weekly tips are now available in an

electronically searchable CD format! Get more than 400 tips,

tricks, and shortcuts, covering 15 different applications and

technology topics, for only $19.95, plus FREE shipping!*



For more information, or to order now, go to:

http://www.elementkjournals.com/buy/showPromo.asp?coupon=115807



*Free shipping applies to U.S. residents only.



********** SUBMIT A TIP! **********



Do you have a shortcut or technique that's tip worthy? If so,

send it to ima_editor@elementk.com . If we use your submission,

we'll include your name and email or Web address, along with

the tip.



********** SERVICES **********



Want to sign up for your own tips? If this tip was forwarded

to you by a friend and you would like to receive your own

FREE tips, sign up at

http://www.elementkjournals.com/tips.asp



This weekly tip is delivered to you as a free service from

Element K Journals,

http://www.elementkjournals.com/tips.asp



***********************************************************

Copyright (c) 2005 Element K Content LLC ("Element K"). All

rights reserved except the right to make private,

noncommercial use hereof. The content in this email (the

"Tips") is the property of Element K or its affiliates and

is protected by copyright law in the U.S. and elsewhere.

This means that the right to copy and publish the Tips is

reserved, even though the Tips are made available by this

service for free; the Tips may not be copied in whole or in

part or further distributed in any form or medium without the

express written permission of Element K. Questions or requests

for permission to copy or republish any content may be

directed to contentreuse@elementk.com.



All product names or services identified throughout this

email are trademarks or registered trademarks of their

respective companies. QuickSkill and QuickSkill 3 CBT are

trademarks of Element K LLC.



********** CHANGE YOUR EMAIL ADDRESS **********

Do you want your tips sent to a new email address?

Simply submit an email to customer relations at

http://www.elementkjournals.com/custserv/tipsemail.asp



**************************************************************



-----------------------------------------------------------

To discontinue your subscription to this tip, please click the link below:

Unsubscribe me from this tip only



To discontinue all communication from Element K Journals

via email, please click the link below:

Unsubscribe me



If you experience any problems with the links above, or would like to

speak with one of our customer relations representatives, please call our

customer relations team at 1-800-223-8720. (Canada: (877) 203-5248,

Outside of the U.S. and Canada: (585) 240-7301).



Element K Journals

500 Canal View Blvd.

Rochester, New York 14623



------------------------------------------------------------

Email sent by Element K using software from M4Internet.

------------------------------------------------------------