469,299 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

Disable spell-checker in MS Access Run-time

Hi all,

I am a MS Access developer using VB 6 (yes, I know it is a bit
old). The problem I am having is, I have a software that allows my
customers to put in the information of their clients. A client of one
of my customer has a last name of "Cotten". Whenever they put in the
last name as "Cotten", the spell checker automatically converts it to
"Cotton". The thing is, I am sending them the run-time version of
Access. Many of my customers do not even have the full version of MS
Access; and because of that, they won't even be able to open up spell
checker in Access. My quesiton is, is there a way to use VB code to
disable spell checker?

Thanks in advance,
Monte

Mar 3 '07 #1
4 5928
sw***********@gmail.com wrote:
Hi all,

I am a MS Access developer using VB 6 (yes, I know it is a bit
old). The problem I am having is, I have a software that allows my
customers to put in the information of their clients. A client of one
of my customer has a last name of "Cotten". Whenever they put in the
last name as "Cotten", the spell checker automatically converts it to
"Cotton". The thing is, I am sending them the run-time version of
Access. Many of my customers do not even have the full version of MS
Access; and because of that, they won't even be able to open up spell
checker in Access. My quesiton is, is there a way to use VB code to
disable spell checker?

Thanks in advance,
Monte
On a per-control basis you can set AllowAutoCorrect to No.

At their end they can disable that specific AutoCorrect in either Excel or Word
because the Spell Checker is common across all Office apps.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Mar 3 '07 #2
On 3 Mar 2007 12:00:06 -0800, sw***********@gmail.com wrote:

Actually, that's not the spell checker, but a feature called Name
Autocorrect which you can easily turn off under the Tools menu.
That's a good idea for other reasons as well, see:
http://allenbrowne.com/bug-03.html

-Tom.
>Hi all,

I am a MS Access developer using VB 6 (yes, I know it is a bit
old). The problem I am having is, I have a software that allows my
customers to put in the information of their clients. A client of one
of my customer has a last name of "Cotten". Whenever they put in the
last name as "Cotten", the spell checker automatically converts it to
"Cotton". The thing is, I am sending them the run-time version of
Access. Many of my customers do not even have the full version of MS
Access; and because of that, they won't even be able to open up spell
checker in Access. My quesiton is, is there a way to use VB code to
disable spell checker?

Thanks in advance,
Monte
Mar 3 '07 #3
Tom van Stiphout wrote:
On 3 Mar 2007 12:00:06 -0800, sw***********@gmail.com wrote:

Actually, that's not the spell checker, but a feature called Name
Autocorrect which you can easily turn off under the Tools menu.
That's a good idea for other reasons as well, see:
http://allenbrowne.com/bug-03.html

-Tom.
I believe spelling AutoCorrect and Name AutoCorrect are two completely different
things. Name Autocorrect does not affect data, but names of objects. His
problem is caused by spelling AutoCorrect.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Mar 3 '07 #4
On Sat, 3 Mar 2007 14:12:53 -0600, "Rick Brandt"
<ri*********@hotmail.comwrote:

Got you.
-Tom.

>Tom van Stiphout wrote:
>On 3 Mar 2007 12:00:06 -0800, sw***********@gmail.com wrote:

Actually, that's not the spell checker, but a feature called Name
Autocorrect which you can easily turn off under the Tools menu.
That's a good idea for other reasons as well, see:
http://allenbrowne.com/bug-03.html

-Tom.

I believe spelling AutoCorrect and Name AutoCorrect are two completely different
things. Name Autocorrect does not affect data, but names of objects. His
problem is caused by spelling AutoCorrect.
Mar 3 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Vish | last post: by
1 post views Thread by Lloyd Dupont | last post: by
1 post views Thread by bill | last post: by
3 posts views Thread by John Wright | last post: by
4 posts views Thread by BillE | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.