[mso] Re: Data entry in Access 2003

  • From: "Tillotson, Robert N (US SSA)" <robert.tillotson@xxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Wed, 2 Apr 2008 14:42:24 -0400


This is a very annoying misfeature introduced with Access 2000. There is
no way to turn it off in table or query datasheets. As a solution use
forms.  Create a columnar or tabular entry form.  Tabular is sort of
like the table data view. =20

I think this may be able to be disable in Access 2007, but, as I don't
use it, I cant't be sure.

Robert Tillotson
BAE-IT
Groton Field Office
860-441-2207

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Pruscoe@xxxxxxx
Sent: Wednesday, April 02, 2008 1:57 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Data entry in Access 2003

I am entering data in the table view in Access. The table has multiple =20
columns of various types (most are text). If I enter numbers in two
consecutive =20
columns, Access assumes I am entering a number series, and it defaults
each  of=20
the following columns to the value it thinks should be entered.=20
=20
How can I disable this "feature?"


**************Planning your summer road trip? Check out AOL Travel
Guides.   =20
=20
(http://travel.aol.com/travel-guide/united-states?ncid=3Daoltrv0003000000=
0
016)


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: