Auto Correcting Words (1 Viewer)

[David_P]

I am having a problems with VBA. When I typed in the word for a form, VBA changed it to a different word (I want Transactions & VBA changes it to tRANSACTIONS) so when I try to run the vba code I get and error. I have tried to do a replace all to replace the word with the one I want but VBA changes it to the word it thinks I want.

How do I turn off this auto correction or make it correct the original word so it chnages all the words to the correct typed word?

I don't want to have to use a different word for I would have to change it in many of my SQL and other places I have the word that refers to a form.

Thanks.

David

 

[gemma-the-husky]

they are the same. Access ignores case differences. so your error is somethnig different, and not related to this.

 

[David_P]

Thanks.

Anyway to correct it though. I like my code nice and neat and easy to read?

 

[gemma-the-husky]

you might find that if you deliberately change it to a different spelling, and then change it back - it may fix it.

be careful, as you may find you need to do a lot more tidying as a result.