Entered text is autocorrecting to VBA phrase

[Dboyce]

I am having difficulty overcoming this problem.

When I enter text in a field that is a VBA phrase, it seems to autocorrect to the capitalized VBA phrase.

I have tried deselecting all the spelling autocorrect select boxes and have set the properties in an affected field to No for allow autocorrect, but this problem still persists.

I also seem to call up a VBA function using the period at the end of a sentence.



Any ideas on solutions?

 

[SOS]

What phrase or word are you trying to use and where?

 

[Dboyce]

When I enter the word on, it corrects to ON.
When I enter other words I know to be typical VBA/SQL words, such as select, it corrects to SELECT.

Also interestingly, when I add a period, a dialog box opens that asks me if I want to use SQL Assistant to connect to a database.

I do use SQL Assistant, but have turned this program off.

Thanks for your further questions.

Dan

 

[missinglinq]

Of particular importance is the where! This is normal behavior in the code module behind, say, a form or report.

 

[Dboyce]

Interestingly, this occurs in only one of the forms in this database, though in all of the text fields in this form.

I would like to see if I can figure out what is causing this problem, rather than just rebuilding the form from scratch.

Since all my text boxes are affected, I feel it is a property that affects the entire form.

Thanks,

Dan

 

[SOS]

Again, WHAT is the phrase you are using? You can't use reserved words for things.

 

[Dboyce]

I haven't experienced any difficulties using reserved words in Access text boxes before and notice this behavior in only one form in the database.

 

[SOS]

I haven't experienced any difficulties using reserved words in Access text boxes before and notice this behavior in only one form in the database.

Fine, but if you don't freakin' answer the question (fully) then we can't explain what is happening. Why the secrecy? Or are we supposed to guess at what you're using.

 

[Dboyce]

The reserve words I am using include on, when, select, null.
All these words cause the same effect in that once entered, the words seem to autocorrect to all caps versions of the words, e.g. ON, WHEN, SELECT, NULL.

As these are reserve words that I know are SQL reserve words, as that entering the period brings up a dialog box that asks if I want to connect to a database using SQL Assistant, I think that somehow this one form is somehow linked to SQL assistant.
SQL Assistant is also a program I use on this computer.

 

[missinglinq]

This is not a "property that affects the entire form!" As described, I think has to be corruption of the form and I'm afraid there won't be any "figuring out what is causing this problem."

The only suggestion I have to to try the old "create a new, blank database and import all the objects into it" routine. This does sometimes kill the demon corruption, and only takes a minute or so to do.

Good Luck!

 

[Dboyce]

I have tried creating a new blank database and importing everything into it, but the noted behavior follows into the new database.

Thanks for your assistance. I will keep working at it.

Dan

 

[missinglinq]

Sometimes it works, sometimes it doesn't. I'm afraid you're going to have to bite the bullet and remake the form.

 

[Dboyce]

Thanks for the assistance.

I resolved the problem overnight by uninstalling SQL Assistant, a program I seldom use.

Dan

 

[missinglinq]

So this a was being caused by a third party add-in? If that's correct, you ought to drop the developers a note telling them about the bug.

Glad you got it fixed!