Hi. I'm sorry to say that after checking MSDN, help entries and the Access object model I've not come across a means of setting the specific global autocorrect settings for Access. SetOption does not appear to support the ReplaceText component of the AutoCorrect option dialogue, as it does not appear in the properties that can be set from VB (see
this link from MSDN for reference).
Further, although there is an Autocorrect object in Access it does not have the same properties as the same-named Autocorrect object in Excel.
Had this been Excel you could simply have written
- Application.AutoCorrect.ReplaceText = False
but Access does NOT support this, as the Access AutoCorrect object has no equivalent properties to the Excel AutoCorrect object.
I would suggest that in the circumstances you will have to turn off autocorrect for each of the textboxes or other controls concerned individually. This can be done from the properties of the textbox itself in design mode, by setting Allow Autocorrect to No, or in VBA like this:
- Me!YourTextBoxName.AllowAutoCorrect = False
I find it somewhat concerning that there are such limiting differences in the behaviour of application objects of the same name within the Office environment.
-Stewart
1
