Access fixes released in Version 2604 (Build 16.0.19929.20090)

Bug Name

Issue Fixed

Values display in the wrong control when using a form as a sublist

If you’ve noticed that values displayed in the wrong control while using a form as a sublist (or subdatasheet), rest assured that this issue is now resolved. The values will appear in their intended places.

Applications that use the Access Database Engine (ACEOLEDB) terminate unexpectedly on exit

Some third-party applications relying on the Access Database Engine (ACEOLEDB) might have closed unexpectedly. We’ve fixed the shutdown sequence, ensuring a smooth exit.

Long Text field corrupted when a query updates a record while a user is editing it

A problem occurred when a query tried to update a Long Text field while it was being edited, potentially causing corruption. This update now handles concurrent access properly, keeping your data safe.

Rendering errors with Aptos (Detail) font

If you were seeing misalignment or garbled characters when using the Aptos (Detail) font, that’s been fixed. The font should now render correctly.

Standard colors in Access didn’t match other Office apps

The colour palette in Access differed from other Office applications such as Word and Excel. It’s been updated, ensuring a consistent look across your Office apps.

Option Group with Vertical Anchor Bottom: option buttons show incorrect visual state after clicking

Previously, clicking an option button in a Vertical Anchor Bottom option group didn’t update its appearance correctly. This issue is now resolved, so the visual state will change as expected.

Query Design: Insert/Delete Columns don’t work when ribbon is set to Show Tabs Only

If you found that the Insert or Delete Columns commands in Query Design were unresponsive when the ribbon was set to “Show Tabs Only,” you’re in luck! They now work flawlessly, no matter the ribbon display option.

SQL View: Ctrl+K should toggle pretty formatting off/on

The Ctrl+K shortcut didn’t toggle SQL formatting in the Monaco SQL editor. Now, it functions as intended, allowing you to easily switch pretty formatting on and off.

Monaco editor incorrectly converts Unicode characters in SQL view

Switching between Design View and SQL View might have caused some Unicode characters to convert incorrectly in the Monaco editor. You’ll be pleased to know that this has been fixed, and your Unicode characters will remain intact.

Importing text files with Unicode characters in the filename fails

If you experienced problems when importing text files with Unicode characters in their filenames, we’ve sorted that out! Imports will now succeed without any hiccups.

Added VarP and StDevP to the Totals query aggregate dropdown

You may have missed the VarP (population variance) and StDevP (population standard deviation) functions in the Totals row dropdown in Query Design. They’ve now been included, enhancing your capabilities.

Added VarP and StDevP to the datasheet totals row dropdown

The VarP and StDevP functions were also missing in the Datasheet view’s Totals row dropdown. They have now been added, providing consistent access across your work.

Access hangs at shutdown when VBA holds temporary DAO field references

If Access hung while shutting down due to temporary DAO field references created by VBA code, this has been addressed. The cleanup process now functions correctly.

Full Screen Mode ribbon display option does nothing in Access

Choosing the “Full Screen Mode” option from the ribbon didn’t produce any effect before. This option now works properly, allowing you to maximise your workspace by hiding the ribbon.