VBA Editor Auto Refreshing Bug - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

VBA Editor Auto Refreshing Bug

Dan Jackson

4 years ago

Has anyone else been typing code and found that the VBA window (After 1 second) will remove spaces and red partial code lines?

Its just started happening today and unless i type really quick - i lose spaces and get vba errors and red text while i'm still typing. Its almost as if someone is pressing something on my keyboard!!!

Some points:
- Only started happening today on my months old project
- Happens on other Modules, even ones i havent edited in ages
- Only affects VBA in access - doesn't affect Notepad for example
- Compact & Repair, Compile and restarting PC didn't resolve it

I haven't changed any other settings that i'm aware of. A quick google says this was a bug in 2007/2010 but i'm assuming that would be fixed by now?

This pretty much sums it up
https://social.msdn.microsoft.com/Forums/office/en-US/3353f2d3-7e92-424b-934c-0eedd21b9a90/excel-2010-vb-editor-auto-deleting-spaces?forum=exceldev

	Scott Axton @Reply 4 years ago
I haven't seen that issue so far. You don't happen to have a timer running do you? That will steal the focus.

	A Glenn Yesner @Reply 4 years ago
I'm experiencing that in Access 365. I start typing and take my eyes off the screen and when I look back it's all messed up. Sometimes while I'm typing a space the space disappears and my cursor is typing out of order. Presently I'm revising existing code in forms and reports and it has been an issue with me for a couple of weeks '.

	Dan Jackson OP @Reply 4 years ago
I do have timers but one for 10 seconds and one for a minute - both of which were implemented weeks ago. This keeps occurring every second of typing.

	Dan Jackson OP @Reply 4 years ago
365 here also

	Richard Rost @Reply 4 years ago
If you have ANY form with a timer event running in the background, it will mess up your VBA window. I've seen this happen a lot. Shut those forms and it should go away.

	Dan Jackson OP @Reply 4 years ago
Cool, I'll try that out thank you. Could you have a 'sub page' on the troubleshooting page with a collection of issues and how to get around them? Would be handy to have a central place to put known issues and resolutions - be a great addition to the troubleshooting.

	Alex Hedley @Reply 4 years ago
Just search the forums, otherwise that list is very long!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View