Blog Post

Access Blog
2 MIN READ

Access fixes released in Versions 2501 and 2502

lindalu-MSFT's avatar
lindalu-MSFT
Icon for Microsoft rankMicrosoft
Mar 21, 2025

This post covers two versions. 

 

Version 2501 (Build 18429.20132) 

 

Bug Name 

Issue Fixed  

Ctrl+W doesn’t close the query window when using Monaco SQL Editor 

Several keyboard shortcuts that were not working properly when editing with Monaco will now function correctly 

SQL not saved correctly when using Monaco to edit control properties 

When using the property builder for the Row Source property to open the query editor, and editing with Monaco, spaces might be removed from the SQL, making it invalid 

Access terminates unexpectedly when setting “Option to enable Monaco SQL Editor” using Application.SetOption 

Application.SetOption now works correctly to set this option 

When saving a query with a syntax error using the Monaco editor, the error message might be incorrect 

In some cases, the editor would report that comments were only allowed at the beginning of a query, even when this was not the issue. 

File Open dialog doesn’t remember database location when saving backup 

When saving a backup database, the File Open dialog should default to the location of the open database, rather than the default save location 

Series sorting does not work in Modern Chart if series display name has been changed 

The new ability to sort a series in a Modern Chart will now work even if the Display Name of the series has been changed from the default name 

 

Version 2502 (Build 18526.20144) 

 

Bug Name 

Issue Fixed  

Error when saving query after applying a filter in datasheet view 

When the Monaco editor is enabled applying a filter in datasheet view and saving could generate an error 

Copying a query from one database does not transfer comments 

Comments at the beginning of a query should be preserved when copying a query from one database to another 

Form_MouseWheel event not reporting correct count 

The Page and Count arguments to this event were always False and 0, but will now report the correct values 

Some number filter menus not correctly named 

The Number Filters sub-menu had items for “Less Than...” and “Greater Than...”, but these options should read “Less Than or Equal To...” and “Greater Than or Equal To...” respectively 

Cannot use VBA code to set some new Modern Chart properties 

We added some new properties to ChartSeries, for example “Gridlines” and “Word Cloud Shape”, that could be set with the Chart Settings pane. These can now also be set using VBA code. 

 

 

Please continue to let us know if this is helpful and share any feedback you have.  

Updated Mar 21, 2025
Version 2.0

4 Comments

  • Marcelodavid's avatar
    Marcelodavid
    Copper Contributor

    Good corrections!

    But there's a bug (if I can call it that) in the Monaco editor.
    When I indent, save, close, and reopen, the indentation is removed, and everything goes back to a single line or with automatic line breaks, different from the ones I originally defined.

    Another annoying issue is that the autocomplete for fields does not include linked tables.

    And last but not least, Access has always lacked a DataGridView that allows image inclusion, conditional formatting, etc., in a decoupled way. But I don't want to have to register an OCX or DLL to get something close to that.

    Other than that, I'm happy that Access is being remembered by Microsoft. I hope it stays this way for many, many years to come.

    • MendipDataSystems's avatar
      MendipDataSystems
      Brass Contributor

      The removal of indentation, line breaks and other formatting such as changes to font size is a known issue which it is hoped will be addressed in the future. For a full list of known issues and bug fixes, see my article https://www.isladogs.co.uk/monaco-sql-editor

      I disagree with your comment about autocomplete & linked tables. I regularly use Monaco with both local and linked tables and am offered a list of fields in all cases. In fact, Monaco provides a list of ALL fields whether or not the table is used in the query SQL.

      I can tell you that further significant improvements to Monaco are in the pipeline though the details cannot be announced publicly at this time

      • Marcelodavid's avatar
        Marcelodavid
        Copper Contributor

        How great that the indentation bug is already known! I will definitely check the known issues on your website, and I'm really happy to hear that more improvements and fixes are coming! Thank you!

        Oh, and I already visit your website regularly. It’s a source of inspiration for my systems and the content I publish on YouTube about Microsoft Access.

  • Thanks! Good to see the monthly bug fix article resumed after a short gap. I recognize a lot of those items you've fixed!