Hendra
No, these are two different things. Name AutoCorrect only refers to names of fields and tables. The AutoCorrect for text boxes refers to the spelling AutoCorrect that is Office-wide. I have never bothered with turning it off in text boxes unless data being entered is mistakenly corrected by AutoCorrect.
If you want to do this at the control level here is the code to run. As with any major change to a database, you should make a backup first.
Sub AutoCorrectOff()
Dim frm As Form
Dim ctrl As Control
Dim x As Integer
On Error Resume Next
For x = 0 To CurrentProject.AllForms.Count - 1
DoCmd.OpenForm CurrentProject.AllForms(x).Name, acDesign
Set frm = Forms(CurrentProject.AllForms(x).Name)
For Each ctrl In frm.Controls
If ctrl.ControlType = acTextBox Then
ctrl.AllowAutoCorrect = False
End If
Next
Set frm = Nothing
DoCmd.Close acForm, CurrentProject.AllForms(x).Name, acSaveYes
Next
Set frm = Nothing
End Sub
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Agestha Hendra
Sent: Sunday, April 01, 2012 10:08 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Bls: [MS_AccessPros] Allow AutoCorrect Field Properties
Ooh,,,I see.. I knew that feature have to unchek, so uncheking "Track name AutoCorrect info" automaticlly
disable "Allow AutoCorrect" property on all of text boxes...thanx Bill
Regards
Hendra
________________________________
Dari: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> >
Kepada: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Dikirim: Minggu, 1 April 2012 23:52
Judul: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Hendra
You don't have to turn it off on all textboxes. That is another feature that corrects spelling mistakes.
The AutoCorrect you should turn off is under Options>Current database>Name AutoCorrect Options. Uncheck "Track name AutoCorrect info".
You only have to turn it off in this place.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Agestha Hendra
Sent: Sunday, April 01, 2012 9:45 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Bls: [MS_AccessPros] Allow AutoCorrect Field Properties
Bill -
I have used it for my application,,,really great codes..thanx Bill..
Would you give me vba codes to Turn Off "Allow AutoCorrect" all of text boxes property in our FE..?
Hendra
________________________________
Dari: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> <mailto:wrmosca%40comcast.net> >
Kepada: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Dikirim: Minggu, 1 April 2012 23:35
Judul: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Open each table? Use the code I wrote (TurnOffSubDataSheets) at
http://thatlldoit.com/codesamples.aspx#anchor4
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile/Bill.Mosca>
https://mvp.support.microsoft.com/profile/Bill.Mosca
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of John Viescas
Sent: Sunday, April 01, 2012 9:16 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Allow AutoCorrect Field Properties
Hendra-
Those of us "in the know" humorously refer to that "feature" as AutoCorrupt. It
has been known to cause damage - sometimes irreversible - in you database. You
should ALWAYS turn that off. And yes, it will improve performance. While
you're at it, open each of your tables in Design View, display the Properties
window, and set Subform Datasheet to [None]. You have to turn off AutoCorrect
first, or the change won't "stick." Turning that off greatly improves opening
tables because it turns off opening a sub-dataset on the related table(s).
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
--------------------------------
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
agesthahendra@ymail.com <mailto:agesthahendra%40ymail.com> <mailto:agesthahendra%40ymail.com> <mailto:agesthahendra%40ymail.com>
Sent: Sunday, April 01, 2012 5:41 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Allow AutoCorrect Field Properties
Hi All,,, :)
Do we have to set "Allow AutoCorrect" text box property to "No" if we
don't need it..? can it increase the performance ?(If it be setted to
"No")
Regards
Hendra
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar