We fixed an issue that could cause Access to incorrectly handle importing a text file in UTF-8 format. Import Text wizard doesn't handle UTF-8 correctly We fixed an issue that could cause DoCmd.RunCommand acCmdShowDatePicker to stop working if the current control is in a subform. The add tables task pane now reapplies filters when you close or reopen it, or switch tabs.ĭocmd.RunCommand acCmdShowDatePicker doesn't work if current control is in a subform
This update fixed an issue that could cause exporting a report to Excel to stop working with no error message. When exporting reports in Microsoft access to excel, the excel file doesn't get created We fixed an issue that could cause the incorrect day of the week to be displayed for a Date/Time Extended field. We fixed an issue that could cause a Date/Time extended field to be formatted incorrectly when not displaying fractional seconds.ĭate formatting for datetime2 displays incorrect day of week The GoToRecord action now works when focus is in the database navigation pane.ĭatetime2 data type formatting doesn't handle fractional seconds properly GoToRecord action doesn't work when focus is in navigation pane The Date Picker will now display when the focus is on a Date/Time Extended field. We fixed an issue that could cause incorrect parsing of date/time values with AM/PM specified when importing a text file.Ĭalendar icon not appearing for textbox bound to Date/Time Extended Importing text file with date/time values with AM/PM fails to import date/time values We fixed an issue that could cause Narrator to fail to read the labels in the Enter Parameter Value dialog.
Record navigator will now resize appropriately to display full number when there is a large record count.Īccessibility Issue: Screen reader doesn't narrate the label of the edit field in the Enter Parameter Value dialog when running a query Record navigation textbox doesn't display full record count when you have >999,999 records and scroll to the end When searching in the nav pane, leading and trailing spaces are no longer trimmed, leading to more accurate search results. We added the ability to get the precision and scale properties for a table field using the Data Access Objects (DAO) Field properties collection.įilter using a search term that ends in a space does not take the space into account We don't expose Precision/Scale in the field properties collection (SQL Server Migration Assistant)
We fixed an issue where the previously created record appears blank when inserting records into a form that is bound to an ActiveX Data Objects (ADO) record set. Make sure you are on Access Build # 0.20196 or greater.Ī form bound to an ActiveX Data Objects (ADO) record set does not appear correctly when inserting records If you see an issue here that impacts you, and if you are on the current monthly channel build 2206, you should have these fixes.
As we started back in June, we are highlighting some of the fixed issues that might be important to you, which our Access engineers released in the current monthly channel version 2206, released on June 29th, 2022