Restore the Access Date Picker in 64-Bit Office
Question details
Restore a date picker in Microsoft Access after installing 64-bit Office.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- An Access application uses a legacy date picker ActiveX control.
- Observed behavior
- The date picker control may be unavailable in 64-bit Office because the legacy control is a 32-bit component.
In Access, select File > Account > About Access to check whether Office is 32-bit or 64-bit. Confirm that your Office license includes Access and check whether other Office applications or add-ins require 64-bit Office.
Install 32-bit Office to use the legacy Access control
Use this option when the application depends on a 32-bit date picker ActiveX control.
Identify the date picker used by the Access application and confirm that its 32-bit version is available for installation.
In Windows, open Settings > Apps, find Microsoft 365 or Microsoft Office, and select Uninstall. Remove other 64-bit Office products, such as Visio or Project, if installed.
Sign in to your Microsoft account and open Services & subscriptions, or use your organization's Office installer. Select the installation options for 32-bit Office and install an edition that includes Access.
Open the database in Access and test the form. If the control is still unavailable, install or register the required 32-bit control using the application's installation instructions.

Use the built-in Access calendar for a Date/Time field
Use the built-in calendar instead of the legacy ActiveX control when a standard date picker meets your needs.
Manage date-based spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office documents and spreadsheets. It can help you move spreadsheet-based date tracking into a familiar workspace, but it does not fix Access ActiveX controls or replace an Access database application.

Frequently Asked Questions
Why is my Access date picker missing in 64-bit Office?
A legacy date picker may be a 32-bit ActiveX control, which cannot run inside 64-bit Access. Check File > Account > About Access to confirm your Office architecture.
Does installing 32-bit Office always restore the control?
It can restore compatibility with a 32-bit control, but the control must also be installed and registered as required by the application. Test the form after installing 32-bit Access.
Where is the built-in calendar setting in Access?
Open the form in Design View, select the date text box, and open its Property Sheet. On the Format tab, set Show Date Picker to For dates for a text box bound to a Date/Time field.
Can WPS Office fix an Access ActiveX control?
No. WPS Office does not fix Access ActiveX controls or replace an Access database application. WPS Spreadsheets can be an alternative for date tracking in Excel-compatible files.




