AutoCorrect At Table Level?

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

This is so weird...Using AXP. Have DB for participant
distributions. A record was set up for a Mr. John Werre.
After a series of keystone cops episodes, it was
determined that no matter how you type it (on the form or
even down at the table level), the last name field will
not allow WERRE. It automatically resets it to WERE. You
may type WERRRE, you may type WERRIE, but you may NOT type
WERRE. I have tried to correct and even used a space but
you CANNOT type WERRE in that field. This DB has been in
use for nearly 5 years and we cannot recall this type of
thing ever happening. Any ideas? I have looked at the
table in design view and can find no hint of what is going
on.

Thanks in advance for any advice or information!!!
 
This is the AutoCorrect option, found in the Tools menu. You can delete the
entry which automatically changes 'werre' to 'were'.

Or, if you want, you can turn off AutoCorrect for all the textboxes on your
form as follows:

1. Open the form in design view
2. Open the form's properties page
3. Immediately click on the TextBox icon in the ToolBox. The Property
sheet's caption will change to "Default Text Box".
4. Look for the "Allow Auto Correct" property
5. Set it to 'No'


hth,
 
Actually, I found it some time ago in a 1999 post from Michael Kaplan. (My
apologies, Michael, for not crediting you!)

As far as I can see, it works on one form at a time. The original post
goes on to say that you can do this on a new form with no controls on it and
then make that form a template. Here's the link to that post:

http://tinyurl.com/2b5ge
 
THANK YOU VERY VERY MUCH!!! I knew it would be something
to do with auto but had never seen the default text
properties. I changed the property default to no and then
had to change the field properties to no also.

I REALLY appreciate your fast reply!!!
 
Back
Top