VBA & Macro Problems

Fix Spaces Disappearing While Typing Access VBA Code

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 869 views

Question details

The user needs to stop spaces from disappearing and symbols from moving while entering VBA code in Access.

Fix Spaces Disappearing While Typing Access VBA Code
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.
Before you start

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.

Solution 1Recommended

Close forms that use a Timer event while editing VBA

Use this quick workaround when an open form's timer is interrupting code entry.

1
Find the open form

Return to the Access window and identify the open form that uses a Timer event.

2
Close the form

Close the form using its document tab's Close command or close button.

3
Resume editing

Press Alt+F11 to return to the VBA editor and check whether spaces and symbols remain in place as you type.

Close forms that use a Timer event while editing VBA
Timer behavior: The form's timed actions will not run while the form is closed. Reopen it when you need those actions again.
Free Microsoft Office alternative

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.

A familiar interface for everyday Office tasksCompatibility with Microsoft Word, Excel, and PowerPoint formats such as DOCX, XLSX, and PPTXA free, lightweight suite for documents, spreadsheets, and presentationsKeep working with compatible Office files while troubleshooting Access separately
microsoft office alternative - wps office

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.