Disable spell-checker in MS Access Run-time

[sweetguy1only]

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

[Rick Brandt]

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

[Tom van Stiphout]

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

[Rick Brandt]

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

[Tom van Stiphout]

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.