Fix Microsoft Access Security Warnings When Using Input Masks
Question details
The user needs to resolve a security warning that appears when using an input mask in Microsoft Access without enabling unsafe database content.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Using an input mask in an Access database that may be in an untrusted location or contain blocked macro or VBA content.
- Observed behavior
- Access displays a security warning, and the input mask does not work. Another warning may appear after clicking OK.
Record the exact warning text and verify the database's source before changing any security settings. If antivirus software identifies malicious content, stop using the file and request a safe replacement rather than trusting or unblocking it.
Identify whether the warning concerns unsafe content or a blocked feature
Start here to distinguish a trust restriction from an antivirus detection or an input mask configuration issue.
An input mask is a field or control property and does not inherently require a macro. A warning encountered while using it may instead involve the Input Mask Wizard, associated VBA code, or other active content in the database.
When Access displays the warning, record its full text before clicking OK. If another warning appears, record that message too, especially any reference to macros, VBA, antivirus software, or administrator policy.
Open your antivirus application's detection history and look for the database file. On Windows with Microsoft Defender, open Windows Security > Virus & threat protection > Protection history. Do not restore or allow content identified as malicious just to make the input mask work.
If the file is safe to inspect, open the table in Design View, select the affected field, and check Field Properties > General > Input Mask. For a form, open Design View, select the text box, and open Property Sheet > Data > Input Mask. Confirm whether the warning occurs while opening the wizard or while entering data.

Unblock a verified database or use a narrowly scoped trusted location
Use this only when the database is verified as safe and the warning concerns downloaded-file restrictions or an untrusted location.
Review Access macro settings and administrator restrictions
Use this when a verified database still reports blocked VBA or macro content after file and location checks.
Use WPS Office for Documents and Spreadsheets Alongside Access
WPS Office is a free, lightweight alternative for everyday document, spreadsheet, and presentation work. Its familiar interface and Microsoft Office format compatibility make migration straightforward for those files. It does not run Access databases or fix Access input mask security warnings.

Frequently Asked Questions
Does an Access input mask require macros to be enabled?
Not inherently. An input mask is a field or control property. Check the field in Table Design View > Field Properties > Input Mask, or the text box in Form Design View > Property Sheet > Data > Input Mask. The wizard or associated database code may be what triggers the security warning.
Why does another warning appear after I click OK?
Clicking OK dismisses a message but does not necessarily resolve the restriction. Record both warnings and check whether they identify different causes, such as blocked VBA content and an antivirus detection.
Where can I add a trusted location in Microsoft Access?
Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location. Use a dedicated folder containing only verified databases, and follow your organization's security policy.
What if the database's Properties window has no Unblock checkbox?
The file may not have a Windows downloaded-file marker, or that option may not be available in its current location. Do not assume the file is safe. Check the exact Access warning, antivirus detection history, and Trust Center settings to identify the restriction.
Can WPS Office open the Access database and fix the warning?
No. WPS Office does not run Access ACCDB or MDB databases, Access VBA, or input masks. For spreadsheet work, export approved data from Access using External Data > Export > Excel or Text File, then open the exported XLSX or CSV file in WPS Spreadsheet.




