auto correct

[dtatham]

We have an application running in Access 2000. We are having a problem with
the auto-correct feature. Even though we have turned off the auto-correct if
it finds an exact entry in the dictionary it makes the change anyways. When
I delete the entry out of the dictionary it does not try to make changes. I
tested this using Access 2002 and when I turn off the auto-correct it does
not make the change even though the word is in the dictionary. Is this a
problem with just Access 2000? Is there a way to change the dictionary that
Access is using so that we could clear out all of the entries but have Word
using the original one? Any other suggestions?

 

[Larry Linson]

Do you have all the Service Packs and updates applied to Access 2000? It was
arguably the second most buggy release of Access when it first came out and
_needs_ the fixes. But, it is much better with all the SPs and updates.

Larry Linson
Microsoft Access MVP

 

[Allen Browne]

Just to clarify, are you talking about unchecking the boxes under:
Tools | Options | Name AutoCorrect
or are you talking about setting the Allow AutoCorrect property of all the
text boxes and combos on all the forms in your database?

Those are 2 different things.

 

[dtatham]

Yes it has all the updates.

Do you have all the Service Packs and updates applied to Access 2000? It was
arguably the second most buggy release of Access when it first came out and
_needs_ the fixes. But, it is much better with all the SPs and updates.

Larry Linson
Microsoft Access MVP

 

[dtatham]

Yes I am talking about unchecking all the boxes under Tools | Options |
AutoCorrect

 

[Allen Browne]

That setting has no effect at all on the spelling autocorrection.

 

[dtatham]

Sorry I misread your post. The option is under Tools | Options | Spelling \
Autocorrect Options

 

[Allen Browne]

How about setting the Allow AutoCorrect properties of your text boxes and
combos to No on all forms instead?

 

[dtatham]

Yes, I was considering doing that as well however, it is a lot of forms and
fields to do. Is there a way to globally turn if off for the whole database?
or for the whole form?

 

[Allen Browne]

Below is some aircode to disable AllowAutoCorrect for all text boxes and
combos in the current database.

Backup your database before running this!!! It makes wholesale changes and
saves them without any confirmation, and it has not been tested.

Function FixForms()
Dim accobj As AccessObject
Dim frm As Form
Dim ctl As Control
Dim strDoc As String

For Each accobj In CurrentProject.AllForms
strDoc = accobj.Name
DoCmd.OpenForm strDoc, acDesign, WindowMode:=acHidden
For Each ctl In Forms(strDoc)
Select Case ctl.ControlType
Case acTextBox, acComboBox
If ctl.AllowAutoCorrect Then
ctl.AllowAutoCorrect = False
Debug.Print strDoc & "." & ctl.Name
End If
End Select
Next
DoCmd.Close acForm, strDoc, acSaveYes
Next
End Function