472,111 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,111 software developers and data experts.

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 6094
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.