Forum Discussion
MS Access application breaks when the new windows "Text Cursor" feature is activated
This post describes a really bizarre bug and it may save you a ton of debugging time in the future.
As you know, there are two basic ways of opening and closing forms in MS Access:
1) use DoCmd.OpenForm to open and DoCmd.Close to close a form
2) create a new instance of the form using using VBA eg. set formRef = new Form_MyForm; formRef.visible = true. Then close the form by set formRef = Nothing.
If you are using method #2, and you decide to turn on the "Text Cursor" feature of windows then method #2 completely breaks !
When you set the form reference to Nothing, that form remains open. Imagine creating a large app that uses method #2 and now Text Cursor breaks the entire app !
Microsoft please look into this and fix it.
1 Reply
- Interesting scenario. My guess is that this particular scenario is relatively rare and, therefore, probably not very high on the list of really critical bugs that need to be addressed, though.
