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.  

​Microsoft Tech Community – Latest Blogs –Read More