Fix Spaces Disappearing While Typing Access VBA Code
Question details
The user needs to stop spaces from disappearing and symbols from moving while entering VBA code in Access.

- Product
- Microsoft Access VBA editor
- Device & OS
- not provided
- Scenario
- Editing VBA code while an Access form that uses a Timer event is open.
- Observed behavior
- Spaces disappear and symbols move unexpectedly during code entry; a running form timer can interrupt typing.
Identify any open Access forms that use a Timer event. If you plan to change a form's Timer Interval, note its current value so you can restore it afterward.
Close forms that use a Timer event while editing VBA
Use this quick workaround when an open form's timer is interrupting code entry.
Return to the Access window and identify the open form that uses a Timer event.
Close the form using its document tab's Close command or close button.
Press Alt+F11 to return to the VBA editor and check whether spaces and symbols remain in place as you type.

Set the form's Timer Interval to zero
Use this option to disable the form timer temporarily while you edit code.
Work with Office files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with compatible Office documents, spreadsheets, and presentations. It makes moving everyday files straightforward, but it does not fix the Access VBA editor or replace an Access database.

Frequently Asked Questions
Why do spaces disappear while I type in Access VBA?
A Timer event on an open form can interrupt text entry in the VBA editor. Close the form and try typing again to see whether the behavior stops.
Where can I find a form's Timer Interval?
Open the form in Design View, press F4, select Form in the Property Sheet, and look for Timer Interval on the Event tab.
What happens if I set Timer Interval to 0?
The form's Timer event stops running. Restore the original nonzero value in the form's Property Sheet when you need its timed actions again.
Does WPS Office fix the Access VBA editor?
No. Close the timer form or change its Timer Interval in Microsoft Access. WPS Office is an alternative for compatible documents, spreadsheets, and presentations, not a fix for Access VBA.




