Week in Review: September 26, 2026
Highlights include a new built-in feature to create cascading combo boxes, tips for getting and setting the Office language via VBA, and a talk on UserForms in Office.
Just Published
This section includes videos, articles, and (occasionally) open-source project updates from the past 7 days.
Articles
Article descriptions generated by claude-opus-4.8.
- Official Access Blog
- Fixes in Microsoft Access - Version 2609 (Build 16.0.20430.20092), by Shane Groff: Lists the fixes in Access version 2609, primarily addressing zoom-related display and alignment issues on forms plus several forms-and-reports rendering bugs.
- Create cascading combo boxes and list boxes in Access - without VBA, by Shane Groff: Explains how to build cascading combo boxes and list boxes declaratively using the new Link Master Fields and Link Child Fields properties instead of AfterUpdate event code.
- Access Forever
- Expanded Form/Report Sizes + Cascading Combo/List Boxes, by Karl Donaubauer: Describes two version 2609 features—the removal of the 22-inch form and report size limit and the new cascading combo and list boxes—including the VBA Properties collection syntax required to work with them.
- Alessandro Grimaldi
- New VBA Tool: Cell Radar: Announces Cell Radar, an Excel add-in by Alessandro Grimaldi that flags formula problems in a side pane.
- Daniel Pineault (DEVelopers HUT)
- A New Look for DevHut: Announces a redesigned theme for the DevHut site aimed at cleaner, faster navigation and now supporting comments.
- Colin Riddington (Isladogs on Access)
- Access Bug Summary - Sept 2026: Summarizes Access bugs and issues reported during September 2026 along with lists of fixes made in Current Channel and Beta Channel builds.
- Change Office Language Using Code: Demonstrates how to change the Office language via VBA by editing registry values and using the GetLocaleInfoEx API to display and select installed languages.
- Restart Current Database Using Code: Presents VBA code to safely close and relaunch the current database, useful after changing options that require an Access restart.
- Get Office/Windows Language Info Using APIs: Shows how to retrieve Office and Windows language information using Windows locale APIs rather than a reference table, keeping results current as Microsoft adds new languages.
- Get Office/Windows Language Info Using Code: Explains how to obtain the current user's Office language via the Application.LanguageSettings LanguageID property and a lookup table, since the new SysCmd actions omit language information. (UPDATED)
- George Hepworth (Grover Park Consulting)
- Calling Volunteer Testers: Open Template Scaffolds Gets Its Public Debut: Requests volunteer testers for the Open Template Scaffolds library ahead of its debut at the October 1 Pacific AUG and October 7 Europe AUG meetings, where the author will present the Scaffold and Outcome-First approaches respectively.
- Mike Wolfe (NoLongerSet)
- Throwback Thursday: September 24, 2026: Revisits past articles on Access UI design, including a technical tip on creating custom right-click menus and modern UI articles by Marcus Dieterle.
- twinBASIC Update: September 22, 2026: Covers twinBASIC developments including a Direct2D touch-gesture image demo by fafalone, a Discord discussion on enhancing Debug.Print, and a preview of forthcoming DDE support.
Videos
- Access User Group Recordings (YouTube channel)
- You're Not Using Microsoft Copilot Alone (15): Join the Global Launch on October 23 (hosted by Access MVP Juan Soto)
- Exploring UserFoms - Access, Word, Excel, PowerPoint, VBA applications (46:15): with Crystal Long
- Alessandro Grimaldi (YouTube channel)
- Cell Radar for Excel (01:41): Find the mistakes hiding in your workbook
- Richard Rost (YouTube channel)
- Video Quiz B1.9 (03:56): What Happens When You Edit a Select Query Result in Microsoft Access?
- 20 Years! (04:18): Computer Learning Zone YouTube Channel Celebrates 20 Years and 3.3 Million Watch Hours
- Video Quiz D2.2 (04:21): Where Can a Private VBA Procedure Be Called From Within Microsoft Access?
- Open Form Module (14:31): Open the Current Form's VBA Module from the Quick Access Toolbar in Microsoft Access
- FormatConditions Bug (13:18): Microsoft Access Error 7966 FormatConditions Conditional Formatting Bug in VBA
- Video Quiz A3.1 (03:21): What Does RGB (0,0,255) Mean for Control Text Color in Microsoft Access?
GitHub Projects
Changelog summary generated by Claude Opus 5.
MCP-Access Four releases in four days — v0.7.60 through v0.7.63, September 21 to 24 — and every one of them came back from somebody using the server against a real database rather than from a test.
v0.7.60 started with a 64-bit audit that came back clean and wasn't: access_vbe_search_all reported the physical line it matched, so a Declare wrapped across three lines with _ continuations surfaced without its return type, hiding a handle that truncates to 32 bits — matches now carry statement_line, end_line and a joined content_full, while an ordinary single-line hit stays byte-identical to v0.7.59. v0.7.61 found the same defect in the other text format the server reads, after a field report from long sessions using it to read an old application: SaveAsText splits long quoted property values across physical lines, and the control parser kept the first fragment and dropped the rest in silence, so a ControlSource ending at …*1 instead of …*100)/Nz([Total])/100) parsed cleanly, looked complete, and reached production as figures a hundred times too large — the same release added access_search_controls, which matches against the joined value so a term falling across the split is actually found. Running that new parser against a real export instead of a fixture immediately exposed an older bug sitting behind it, fixed in v0.7.62: .strip('"') had been chewing through a value's own closing quote whenever the value ended in one, so ="=\"Ref: \" & [OrderNo] & \"\"" came back mutilated. And v0.7.63, reported and fixed by @profesor-franhuertas, corrected a different sort of wrong answer — Access loads a referenced library's VBA project into the same collection as the host and makes it the active one, so reference listings and compile checks had been quietly inspecting the wrong database entirely.
Three of the four are the same shape: a value that came back looking whole. What ties the week together is where they came from — an audit, an archaeology session, and a real export, none of which a fixture would have caught.
New to Me
This section includes content I discovered this week that has been around for a while.
- Nothing new this week.
Upcoming Access User Group Events
NOTE: Only English-language user group meetings with scheduled guest speakers or topics are listed. For a complete list of upcoming events, visit the Access User Group event calendar.
- [September 29, 2026] Maria Barnes: Access Lunchtime – using AI for Microsoft Access development
- [October 1, 2026] George Hepworth: Open Template Scaffolds for AI Assisted Development
- [October 7, 2026] George Hepworth: Using AI to create Open Template Scaffolds
- [November 4, 2026] UKAUG Autumn 2026 Conference: In person at The Phoenix in London; speakers:
- Colin Riddington: Sprinkle a little UI Magic on your Apps (in-person version)
- Mike Wolfe: Version Control for Access Developers
- Alessandro Grimaldi: MS Access: More than you think!
- Tim Finch: 3D Rendering in VBA. Helped by new “mate”, Claude
- The Microsoft Access Team
- [November 11, 2026] Colin Riddington: Sprinkle a little UI Magic on your Access Apps
- [December 2, 2026] Mike Wolfe: Using AI for Test Driven Development in Access
Access Roadmap
There were no changes made to the roadmap between the Week in Review last week (2026-09-19) and this week (2026-09-26).
The roadmap was last updated September 14, 2026.
Listed below is a snapshot of the official Access Roadmap.
"In Development", "Rolling Out", and "Launched" are Microsoft terms that I pulled straight from the public roadmap. Dates listed are "rollout start" dates.
In Development
OCT 2026: Rounded corners on Access form controls: We’re making it easier to give your Access apps a polished, up-to-date feel. With the new CornerRadius property, you can add rounded corners to form controls—bringing a softer, more modern look to your designs.SEP 2026: Cascading combo and list boxes with LinkMasterFields/LinkChildFields: Combo boxes and list boxes now support LinkMasterFields/LinkChildFields properties, enabling cascading dropdowns (e.g., Country filters City) without writing VBA code.
Rolling Out
JUN 2026: Design Access forms and reports without 22-inch size constraints: With the removal of the 22-inch limit, your apps can now take full advantage of today’s larger monitors. You can display more data, create flexible layouts, and deliver a better experience on wide and high-resolution screens.
Launched
AUG 2026: Zooming for Continuous Forms and Multiple-Items Forms: Access extends zoom capabilities to continuous forms and pop-up forms, building on zoom support already available in tables and queries. Adjust magnification from 10 percent to 500 percent using the slider in the lower-right corner or controls on the ribbon. Keyboard shortcuts are also available, making it easy to quickly change your view and focus on the details that matter most.MAY 2026: Enable zoom magnification to Microsoft Access for Forms, Tables, Queries: Access will add magnification slider (10% to 500%) in lower right of the application, similar to the feature in Word, PowerPoint, and Excel. It will also be keyboard accessible and available on the ribbon in Access forms, tables, and queries.
Upcoming End-of-Life Dates
Here are the key end-of-life dates Access developers should track:
2024
[JUL 09]SQL Server 2014
2025
[OCT 14]Access 2016|Access 2019|Office 2016|Office 2019[OCT 14]Windows 10[OCT 28]Salesforce ODBC Driver[NOV 11]Windows 11 version 23H2
2026
[JUL 14]SQL Server 2016[OCT 13]Access 2021 | Office 2021[OCT 13]Windows 11 version 24H2
2027
[JAN 12]Windows Server 2016[MAR 01]Auto-migration of Classic Outlook begins for Enterprise users (originally scheduled for April 2026, but postponed to March 2027)[OCT 12]SQL Server 2017
2029
[JAN 09]Windows Server 2019[OCT 09]Access 2024 | Outlook 2024[OCT 09(or later)]Classic Outlook- See "Edit 8/12/2024" at top of this article for official clarification that "both perpetual and subscription [i.e., MS 365] versions of Outlook will be supported until 2029"
- Support for Classic Outlook is guaranteed at least through 9 Oct 2029; it may be extended beyond this date
2030
[JAN 08]SQL Server 2019
2031
[OCT 14]Windows Server 2022
2033
[JAN 11]SQL Server 2022
2034
[OCT 10]Windows Server 2025
Ongoing
- Microsoft 365 (with subscription)
Date TBD
- Complete removal of VBScript from Windows OS (Microsoft Announces the Death of VBScript)