Thanx John...but there are hundred text boxes on many forms in my FE have to setted , involved unbound text box...
do you have vba codes to do that setting..? and how can we get the default text box that the AutoCorrect is setted to No
everytime we want to use text box..? it seems that the default is setted to "yes"...
Regards
Hendra
________________________________
Dari: John Viescas <JohnV@msn.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Minggu, 1 April 2012 23:16
Judul: 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@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Sunday, April 01, 2012 5:41 PM
To: MS_Access_Professionals@yahoogroups.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]
Tidak ada komentar:
Posting Komentar