Group:  Microsoft Access ยป microsoft.public.access.modulescoding
Thread: Turn Off AutoCorrect

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Turn Off AutoCorrect
"Lou Civitella" <lou[ at ]webersystems.com> 25.07.2006 14:08:42
How can I programmactically turn off the autocorrect feature?

Thanks,
Lou


Re: Turn Off AutoCorrect
"Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 25.07.2006 14:16:42
Something like this:
Dim db As DAO.Database
Set db = CurrentDb()
If db.Properties("Perform Name AutoCorrect") Then
db.Properties("Perform Name AutoCorrect") = False
End If
If db.Properties("Track Name AutoCorrect Info") Then
db.Properties("Track Name AutoCorrect Info") = False
End If
Set db = Nothing

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lou Civitella" <lou[ at ]webersystems.com> wrote in message
news:erAKXP$rGHA.1796[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text]
> How can I programmactically turn off the autocorrect feature?


Re: Turn Off AutoCorrect
"Lou Civitella" <lou[ at ]webersystems.com> 25.07.2006 15:24:31
Hi Allen,

I added this code to my Access database but it does not seem to work. Even
if I just use this code
db.Properties("Perform Name AutoCorrect") = False
db.Properties("Track Name AutoCorrect Info") = False

When I go to a text box and typw something like this OSI-LB10-NWE the
AutoCorrect still changes it to OSI-LB10-NEW

I want to disable the Replace text as you type.

Any suggestions?

Thanks Again,
Lou

"Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message
news:eiH34T$rGHA.2124[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text]
> Something like this:
> Dim db As DAO.Database
> Set db = CurrentDb()
> If db.Properties("Perform Name AutoCorrect") Then
> db.Properties("Perform Name AutoCorrect") = False
> End If
> If db.Properties("Track Name AutoCorrect Info") Then
> db.Properties("Track Name AutoCorrect Info") = False
> End If
> Set db = Nothing
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Lou Civitella" <lou[ at ]webersystems.com> wrote in message
> news:erAKXP$rGHA.1796[ at ]TK2MSFTNGP03.phx.gbl...
>> How can I programmactically turn off the autocorrect feature?
>
>


Re: Turn Off AutoCorrect
"Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 25.07.2006 15:35:25
Hi,
I think you need to create these properties:

With db
Set prp = .CreateProperty("Perform Name AutoCorrect", dbLong, 0)
.Properties.Append prp
Set prp = .CreateProperty("Track Name AutoCorrect Info", _
dbLong, 0)
.Properties.Append prp
End With

http://alexdyb.blogspot.com/2006/05/more-on-autocorrect-option.html

you can also install my addin, which automatically switches autocorrect for
any opened database:
http://www.pointltd.com/Downloads/Details.asp?dlID=50

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"Lou Civitella" <lou[ at ]webersystems.com> wrote in message
news:ODidu5$rGHA.2124[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text]
> Hi Allen,
>
> I added this code to my Access database but it does not seem to work. Even
> if I just use this code
> db.Properties("Perform Name AutoCorrect") = False
> db.Properties("Track Name AutoCorrect Info") = False
>
> When I go to a text box and typw something like this OSI-LB10-NWE the
> AutoCorrect still changes it to OSI-LB10-NEW
>
> I want to disable the Replace text as you type.
>
> Any suggestions?
>
> Thanks Again,
> Lou
>
> "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message
> news:eiH34T$rGHA.2124[ at ]TK2MSFTNGP03.phx.gbl...
>> Something like this:
>> Dim db As DAO.Database
>> Set db = CurrentDb()
>> If db.Properties("Perform Name AutoCorrect") Then
>> db.Properties("Perform Name AutoCorrect") = False
>> End If
>> If db.Properties("Track Name AutoCorrect Info") Then
>> db.Properties("Track Name AutoCorrect Info") = False
>> End If
>> Set db = Nothing
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia.
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "Lou Civitella" <lou[ at ]webersystems.com> wrote in message
>> news:erAKXP$rGHA.1796[ at ]TK2MSFTNGP03.phx.gbl...
>>> How can I programmactically turn off the autocorrect feature?
>>
>>
>
>

Re: Turn Off AutoCorrect
"Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 25.07.2006 15:37:13
Sorry: I misunderstood.

You are not talking about the Name AutoCorrect properties of the Database
under:
Tools | Options | General
but the Allow AutoCorrect property of the controls on the form.

If Form1 is open in design view, and has a text box named Text0, use:
Forms![Form1]![Text0].AllowAutoCorrect = False

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lou Civitella" <lou[ at ]webersystems.com> wrote in message
news:ODidu5$rGHA.2124[ at ]TK2MSFTNGP03.phx.gbl...
[Quoted Text]
> Hi Allen,
>
> I added this code to my Access database but it does not seem to work. Even
> if I just use this code
> db.Properties("Perform Name AutoCorrect") = False
> db.Properties("Track Name AutoCorrect Info") = False
>
> When I go to a text box and typw something like this OSI-LB10-NWE the
> AutoCorrect still changes it to OSI-LB10-NEW
>
> I want to disable the Replace text as you type.
>
> Any suggestions?
>
> Thanks Again,
> Lou
>
> "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> wrote in message
> news:eiH34T$rGHA.2124[ at ]TK2MSFTNGP03.phx.gbl...
>> Something like this:
>> Dim db As DAO.Database
>> Set db = CurrentDb()
>> If db.Properties("Perform Name AutoCorrect") Then
>> db.Properties("Perform Name AutoCorrect") = False
>> End If
>> If db.Properties("Track Name AutoCorrect Info") Then
>> db.Properties("Track Name AutoCorrect Info") = False
>> End If
>> Set db = Nothing
>>
>> "Lou Civitella" <lou[ at ]webersystems.com> wrote in message
>> news:erAKXP$rGHA.1796[ at ]TK2MSFTNGP03.phx.gbl...
>>> How can I programmactically turn off the autocorrect feature?


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net