Others

Fix Microsoft Access Error 3270 When Saving or Closing a Form

Maira Mehtab Sep 21, 2026 868 views

Question details

The user encounters Error 3270 when changing dates and attempting to save or close a specific database form, alongside a failing CloseWindow macro.

Product: Microsoft Access
Device & OS: not provided
Scenario: Modifying a form's design by changing embedded dates and attempting to save or trigger a close macro after migrating the database to a new laptop.
Observed behavior: Error 3270 appears, and the CloseWindow macro fails with an unspecified error. However, closing the form without saving the changes works correctly, and other forms in the database remain unaffected.

Before you start

Before troubleshooting the specific error code, verify if the issue is isolated to a single form by creating a blank test form in the same database and attempting to trigger a close action.

Solution 1Recommended

Troubleshoot Form Properties and the CloseWindow Macro

Identify and repair corrupted elements, broken references, or incompatible macros within the specific form causing the error.

Since the error only affects one specific form after moving to a new laptop, the form's internal properties, references, or event macros may have become damaged or are incompatible with the new environment.

Create a test form

Navigate to the Create tab in the Access ribbon and click Form Design to generate a completely new form. Test basic closing macros to ensure the laptop's Access environment is functioning correctly.

Inspect form properties

Right-click the problematic form in the Navigation Pane, select Design View, and open the Property Sheet. Compare its controls and properties with the working test form.

Verify event macros

In the Property Sheet, click the Event tab. Locate the On Close or On Unload events, and click the ellipsis (...) to open the Macro Builder. Review the CloseWindow action for missing arguments or broken control references.

Database Compilation: You can also open the VBA editor (Alt + F11) and click Debug > Compile Database to quickly highlight any broken code references causing the save failure.

Solution 2

Implement a Data-Driven Table Workaround

Store variable inputs like dates in a table rather than hardcoding them into the form design, eliminating the need to save form layout changes.

Free Microsoft Office alternative

Need a Reliable Office Suite for Your Documents and Spreadsheets?

While Microsoft Access handles complex databases, you might need a streamlined, cost-effective solution for your everyday documents, data analysis, and presentations. WPS Office is a free, lightweight suite offering robust word processing and spreadsheets with a familiar interface.

1. Download the software: Visit the official WPS Office website and click the Free Download button to get the installer for your operating system.
2. Install WPS Office: Run the downloaded setup file and follow the straightforward on-screen prompts to complete the installation in minutes.
3. Manage your files: Launch WPS Office to instantly open, edit, or create your spreadsheets, documents, and presentations in one unified workspace.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (docx, xlsx, pptx).Lightweight installation package that runs smoothly and quickly on any laptop.Familiar, intuitive user interface for a seamless and effortless migration.All-in-one workspace featuring built-in PDF editing and conversion tools.

microsoft office alternative - wps office

Frequently Asked Questions

What does Error 3270 mean in Microsoft Access?

Error 3270 typically translates to a 'Property not found' error. It usually occurs when a macro, such as CloseWindow, or VBA code references a form control or property that is missing, damaged, or misspelled.

Why does the CloseWindow macro fail after moving to a new laptop?

Migrating an Access database to a new laptop can expose version incompatibilities, missing library references, or broken trust center settings, especially if the new machine uses a different Office version or lacks components the macro relies on.

Is it a good practice to update dates in Form Design view?

No. Hardcoding variable data like dates into a form's design is not recommended. Best practice dictates storing variable data in tables and using the form merely as a user interface to display or edit those table records.

Office Quick Solutions