By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Disable spell-checker in MS Access Run-time

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.