Our newest round of Access bug fixes was released on January 4th, 2024. In this blog post, we highlight some of the fixed issues that our Access engineers released in the current monthly channel.
If you see a bug that impacts you, and if you are on the current monthly channel Version 2312, you should have these fixes. Make sure you are on Access Build # 16.0.17126.20126 or greater.
|
Bug Name
|
Issue Fixed
|
|
No list of font sizes when Aptos font is selected
|
Aptos is the default font for controls in a new database using the recently updated ‘Office Theme,’ but the font size drop down was not displaying a list of font sizes (although you could manually type in a font size).
|
|
When a query was open in datasheet or design view, the context menu command to open in SQL View in the navigation pane would not switch the open query to SQL View
|
This command on the context menu was recently added to allow opening a query directly into SQL view. However, to be consistent with other commands, it now switches the mode of a query that is already open to SQL view.
|
|
#Error when using DateDiff with one Date/Time column and one Date/Time Extended column
|
The DateDiff function was working correctly if both arguments were of type Date/Time, or both arguments were of type Date/Time Extended but would fail to evaluate with one argument of each type.
|
|
The updated linked table manager no longer shows the name of the DSN used for a linked table
|
The old, linked table manager displayed this information. The new linked table manager now also displays it.
|
|
Access may terminate unexpectedly when running a macro after editing it
|
In some cases, after adding/removing/moving macro actions in the macro designer, then attempting to run the macro, Access would terminate unexpectedly. This no longer occurs.
|
|
F1 does not display the correct help page when used on some properties/methods of the Field2 object in the VBA IDE
|
F1 now directs to the appropriate help page for the following properties/methods:
CreateProperty, Expression, IsComplex, Name, Required, SourceTable, Type, ValidationRule, ValidationText, and Value.
|
|
Some valid values for the DBEngine.SetOption method have no defined constant
|
The following constants were added:
dbPagesLockedToTableLock, dbPasswordEncryptionProvider, dbPasswordEncryptionAlgorithm, dbPasswordEncryptionKeyLength
|
|
Subform control does not support LabelName property
|
The LabelName property was shown in the property sheet for every other control that supported child labels and is now present for subform controls as well.
|
|
Auto expand in combo boxes doesn't work for list items >100 index
|
In some cases, autocomplete did not work for items in a dropdown list when there were more than 100 items in the list. This issue has been resolved.
|
Please continue to let us know if this is helpful and share any feedback you have.
