Access topics

Access VBA performance dramatically slowed since June Update

DavidReed — Fri, 12 Jun 2026 17:25:30 GMT

We are running an access based application with a large vba project.

One customer with four different instances of this project experience extreme slow down in performance on all instances during the last week. We made no changes. The Microsoft Office Update was applied automatically. We believe the problem happened then. We have tried reverting to several different previous versions of Office but symptoms still remain.

Regression in v2606: continuous forms redraw/flicker on main form

DeRochier — Thu, 11 Jun 2026 23:20:22 GMT

As soon as I installed Version 2606 (Build 16.0.20131.20012), all of my continuous subforms on parent forms began constantly redrawing and flickering, making the application almost unusable.

Reverting to Version 2605 (Build 16.0.20026.20140) immediately resolved the issue without any changes to the database. I have since disabled automatic updates and am remaining on Version 2605 until this issue is addressed.

Has anyone else experienced this problem with Version 2606? Is this a known bug, or has Microsoft acknowledged the regression?

Full account lock (Error 0x80004005) on multiple devices and networks. Automated support fails.

johangiron — Thu, 11 Jun 2026 17:53:05 GMT

Greetings to the community and the Microsoft support team,

I am turning to this forum because the automated support system and bots keep me in a closed loop, preventing me from reaching a human agent to resolve a critical lockout on my account.

Currently, I am unable to sign in to my Xbox Live account under any circumstances. The system constantly throws the following error:

Error code: 0x80004005 Message: "We couldn't sign you in to Xbox Live. Sorry, something went wrong. Try again in a while."

As a technician, I have rigorously isolated the variables and can confirm the following to save time on diagnostics:

It is not a local hardware failure: The exact same error replicates when trying to sign in from my Xbox console, my PC, and the mobile app.

It is not a local connectivity (ISP) issue: I have tested this through my home Wi-Fi and different cellular data networks, getting the exact same access denial.

All diagnostics point to the failure being directly at the server level: a token generation issue with my profile, an invisible security lock, or an internal synchronization failure.

I kindly request that a Microsoft Agent or moderator send me a Private Message (DM) here so I can provide the affected email address and have this case escalated to Tier 2 support. I need the internal status of my profile to be checked.

My Xbox Gamertag is: #Non9969

I look forward to your help. Thank you very much.

Text Truncation in Access Report Controls

khippen — Thu, 11 Jun 2026 15:28:57 GMT

Around May 14, 2026, we began experiencing text truncation on the right side of text box controls in Access (Office 365) reports. Approximately 2–4 characters are cut off whenever font size is below 10pt. All reports in our environment are affected and the problem was not present prior to May 14.

We ruled out layout as a contributing factor by verifying page size, margins, report width, control dimensions, padding, and layering were all correctly set. No layout changes resolved the issue. The problem does not occur when font size is set to 10pt or higher, suggesting the update affected font metric calculations for small font sizes.

Steps taken without resolution include adjusting all report and control sizing properties, testing multiple default printer configurations including Microsoft Print to PDF and Adobe PDF, and verifying Windows display scaling was set to 100%.

If anyone has any solutions, please let me know! Thank you for your time.

Can't Run Report

jmp2025 — Tue, 09 Jun 2026 13:56:58 GMT

When I try to run a report, I get this error message. I made sure all of my quarters are accounted for. Any ideas of a fix?

Regression in v2605: Subform with overlapping controls breaks timer in unrelated form

HeinziAT — Wed, 03 Jun 2026 13:23:25 GMT

I found another issue (sorry) which might be caused by the zoom-related changes in 2605. The following repro example works fine in 2604 (Monthly Enterprise Channel) but breaks in 2605 (Current Channel).

Again, this issue is unrelated to zooming itself.

Prepare database

The repro requires three forms and a few controls. Since those are tedious to get right manually, I wrote some VBA code to do that for us. Execute BuildRepro() in the Immediate Window to create the forms and controls.

Option Compare Database Option Explicit Public Sub BuildRepro() CreateFormASubform CreateFormA CreateFormB End Sub Private Sub CreateFormASubform() Dim frm As Form Dim ctl As Control Set frm = CreateForm() Set ctl = CreateControl(frm.Name, acTextBox, acDetail, , , 345, 1140, 1746, 260) ctl.TabStop = False Const textBoxTop = 260 Set ctl = CreateControl(frm.Name, acTextBox, acDetail, , , 56, textBoxTop, 270, 270) ctl.TabStop = False Set ctl = CreateControl(frm.Name, acImage, acDetail, , , 56, 0, 270, 270) Set ctl = CreateControl(frm.Name, acCommandButton, acDetail, , , 60, 795, 5895, 260) SaveAndClose frm, "FormA_Subform" End Sub Private Sub CreateFormA() Dim frm As Form Dim ctl As Control Set frm = CreateForm() Set ctl = CreateControl(frm.Name, acSubform, acDetail, , , 100, 100, 3000, 3000) ctl.SourceObject = "FormA_Subform" SaveAndClose frm, "FormA" End Sub Private Sub CreateFormB() Dim frm As Form Dim ctl As Control Set frm = CreateForm() frm.TimerInterval = 1 Set ctl = CreateControl(frm.Name, acLabel, acDetail, , , 100, 100, 5000, 1000) ctl.Name = "my_label" ctl.Caption = "Waiting for Timer..." frm.HasModule = True frm.Module.InsertText _ "Private Sub Form_Timer()" & vbCrLf & _ " Me.TimerInterval = 0" & vbCrLf & _ " Me.my_label.Caption = ""Done""" & vbCrLf & _ "End Sub" frm.OnTimer = "[Event Procedure]" SaveAndClose frm, "FormB" End Sub Private Sub SaveAndClose(ByVal frm As Form, ByVal newname As String) Dim oldname As String oldname = frm.Name DoCmd.Save acForm, oldname DoCmd.Close acForm, oldname DoCmd.Rename newname, acForm, oldname End Sub

Run repro

1. Open FormA.

2. Open FormB (while FormA is still open).

Expected result: FormB opens completely, the timer runs and the label reads "Done".

Actual result: FormB opens "halfway" (it's visible, but it's tab is still missing, see screenshot below) and the label still shows "Waiting for Timer...". As soon as you right-click anywhere, the form finishes opening and the timer runs, changing the label to "Done".

Notes:

I tried to make the repro as simple as possible. If you remove one of the controls from FormA_Subform (or enable TabStops), the problem disappears.
It might have something to do with overlapping controls: If you change textBoxTop from 260 to 280, so that it no longer overlaps with the image, the problem also disappears.
We need the overlapping controls because in our real code the subform is continuous and displays data at different indentation levels (like a treeview).

Tab header font issue when the "new zoom" feature is enabled

HeinziAT — Tue, 26 May 2026 13:26:02 GMT

We found a curious font display issue, which can only be reproduced if the "new zoom" feature flag is active:

We can reproduce it with build 20026.20076 with the zoom slider visible (e.g. in the "Current Channel (Preview)"), but
we cannot reproduce it on the same build with the zoom slider invisible (e.g. on a freshly updated system in the Current Channel, which has not received the staged rollout yet) or with older builds (e.g. the current Monthly Channel build).

The problem itself is unrelated to zooming.

Repro

1. Create a new Access database.

2. Create a new form in Design View.

3. Add a Tab Control.

4. Set the tab control's "Use Theme" property to "No".

5. Add a button with the following code:

Private Sub Command3_Click() Dim start As Double ' Localize the page name, if you use a non-English version of Access Me.Page2.Visible = True ' Simulate long-running operation (3 seconds) start = Timer Do Until Timer > start + 3: Loop End Sub

6. Save and open the form in Form View.

7. Click the button.

Expected result: Nothing happens for 3 seconds.

Actual result: The tab header's font switches to some old raster system font (MS Sans Serif?). After 3 seconds, the form returns to the 21st century.

This issue is easy to work around: just do the long-running operation before setting the Visibility property, this will reduce the font-change to a short flicker.

Still, this appears to be an unintended side effect of the changes made for the "new zoom" feature, so I thought it might be helpful to report it while that feature is still being worked on.

Access selecting specific date on a calendar

nicoleethier — Tue, 02 Jun 2026 19:54:55 GMT

I'm pulling my hair out because everything I've found through my research says my VBA code should work, but it doesn't!

Here's the story. I have a calendar (form) that shows events going on for each month. What I want is for a person to click on a specific day and have a pop-up form appear showing more details of the events for whatever day they clicked on. I used the below code, which mostly works... When I click on a date, the month and year will be correct, but not the day of the month. The day of the month is always today's day. For example, let's say I click on the day Feb. 2, 2024 and today's date is May 21, 2026. My pop-up form will show the events for Feb. 21, 2024.

This is the code I have:

Private Sub lblTue3_Click() Dim txtSelectDate As Date (probably don't need this) Dim iDayOfMonth As Integer Dim iMonth As Integer Dim iYear As Integer Dim dSelectDate as Date iDayOfMonth= Format(Me.txtSelectDate.Value, "d") iMonth = Format(Me.txtSelectDate, "mm") iYear = Format(Me.txtSelectDate, "yyyy") dSelectDate = CDate(iMonth & "/" & iDayOfMonth & "/" & iYear) DoCmd.OpenForm "frmThatContainsMyData", acNormal, , "[DateOnFormUsedForFilter]=#" & dSelectDate & "#", , acDialog

Update:

I think I figured out where the problem is. When the calendar form is loaded, that's where txtSelectDate is defined. However, I don't know how to define txtSelectDate to whatever date I click on in the calendar. It defaults to today's date when I load the form. When I change the month or year, those number change in the txtSelectDate box, but not the day. This is the code I currently have. (DisplayMonthName displays the month and year; don't think it's part of my issue)

Private Sub Form_Load() Me.txtSelectDate = Date Call DisplayMonthName End Sub

Any help is greatly appreciated!

How do I get support with Authentication when it doesn't work?

workless — Sat, 02 May 2026 14:57:44 GMT

I have a business 365 account but changed address and so my credit card payments stopped. However, I can't log in to my account because I have an authentication problem (my authentication app on iPhone is still working but the entry for this account has gone and there is a new one called "Microsoft Entra ID" but when I go to get the authentication code this "Entra ID" authenticator does not produce it).

To get help from Microsoft it always asks for authentication. I would like to keep this account and start paying again but I can't find a way to get help to fix the authentication problem because raising a ticket or talking to an agent requires authentication.

Stumped on auto populate staying in a combo box

Robert_Massie — Fri, 01 May 2026 15:26:55 GMT

This is embarrassing. I’ve been building databases since 1999 and now I’m stumped

I have an MS Access database with a combo box that is used to select specific records.

These records have two particular fields. A primary key named “Track” and a value associated with it called FTitle. Track is a numeric field and FTitle is text. FTitle shows the job title.

I had this working beautifully on a database for six years. Go into the combo box, start typing in the FTitle and it would auto populate with an FTitle name. I've checked everything. Auto expand and everything else

Two things are happening here. I cannot get an autopopulate combo box to work. It works when I make it. Then when I reopen the form it stops working.

I tried to add options to the existing front end which autopopualted perfectly. It seems that when I added a subform to the form the combo box auto populate on stopped working.

Any advice??

SQL Query editing UI issue

Emiliano76 — Mon, 27 Apr 2026 08:54:35 GMT

Hi everyone.

For a couple of weeks now, my Access hasn't let me edit queries within the SQL option.

Version: Access 2604 (Build 19929.20090)

Basically, when I access the SQL View, I see the SQL code but can't select it or move the cursor to easily edit the text.

It's difficult to explain, but I hope the following video helps:

https://drive.google.com/file/d/1knAAwVS48m8WsarmhLeOVFWOdFuCqaUz/view?usp=sharing

I've already tried restoring and resetting the installation, but to no avail.

I hope you can help.

Bets Regards,
Emiliano

Bold Duplicates (Conditional Formatting)

Tony2021 — Sun, 26 Apr 2026 14:59:34 GMT

Hello experts

I have a form based on qryLCAmends

I want to bold the [LCNo] if there is a duplicate but ONLY where LCID = LCID

here is what I have but it doesnt bold anything:

DCount("*","qryLCAmends","[LCID]=" & [LCID] & "[LCNo]='" & [LCNo] & "'")>1

LCNo is text.

I am using the "expression" in conditional formatting:

Example:

How can I do this with conditional formatting?

ODBC error (incorrect syntax) since 2604

EzAccessGideon — Fri, 24 Apr 2026 11:18:52 GMT

Overnight i have the problem that many inserts in my MS Access app do not work anymore. I get the error

Run-time error '3155':
ODBC--insert on a linked table 'tablename' failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.(#102)

I have been able to isolate this issue on a column of type NVARCHAR(MAX). If I insert any value except null in this column the error above will show on save. I tested with other variants of NVARCHAR. The problem happens starting from NVARCHAR(256), thus what is Long Text for Ms Access. When i insert the record first with a value null for this column, no error is generated and the record is saved. If i 'Update' the record later with a text value in this column, that is no problem.

So, the ODBC connection generates a sql insert statement that is mallformed in case of a long text.

I have this problem consistent on all apps and all tables where i have NVARCHAR(>255).

My solution is to go back to office release 2508 (semi annual support).

version 2604,new bug?

Weichen Yang — Wed, 15 Apr 2026 13:14:51 GMT

access 365 updated to version 2604, does it destory odbc cache? system show sql login windows continuously.

using odbc dns-less to link azure sql database.

After the upgrade, the system became completely unusable.

Unable to use database view option in Access - Microsoft 365

NsdHill21steph — Wed, 08 Apr 2026 17:38:18 GMT

Error - You can't set criteria before you add a field or expression to the Field Row

I need some help on this.

Edge Browser Control stealing Focus

udaytheja — Sat, 04 Apr 2026 19:06:02 GMT

I am facing an issue with the Microsoft Access Edge (WebView2) browser control in VBA Office 365.

I have two forms displayed side by side:

The first form contains a grid/list of records.
The second form contains an Edge browser control that loads an HTML file.

When a record is selected (or navigated using arrow keys) in the grid, I dynamically delete and recreate an HTML file with details of the selected record, and then call the Edge browser control’s Navigate method to load that file.

The problem is:

Arrow key navigation works correctly in the grid when the Edge browser control is not used.
Once I add the Edge browser Navigate call, the browser control takes focus.
After that, arrow key navigation in the grid stops working because focus shifts to the browser.
Attempts to manually set focus back to the grid (SetFocus, timers, etc.) are not reliable. Tried this in documentcomplete event also, but not working.
The issue seems to be related to the asynchronous behavior of the Edge browser control, which keeps reclaiming focus.

What is the best way to reliably prevent or reclaim focus from the Edge browser control so that keyboard navigation in the grid continues to work smoothly?

Multi-line Text Box misleading text and cursor display

RJBrenemanToo — Fri, 03 Apr 2026 14:59:45 GMT

Starting with 365 Version 2603 on 4K monitor, in a multi-line text box, typing multiple words followed by line feeds (Enter key) then moving cursor back up to previous line causes trailing characters to disappear, entering characters at the end of the line shows the new character with the cursor in front of it, and other bizarre behavior. Selecting all the text shows it is all there but trailing characters at the end of a line can disappear depending on cursor position. If I change the monitor resolution to 2K, the issue goes away. If I rollback to version 2602 the issue goes away. This is an issue with version 2603 on 4K monitors. We have many customers reporting the same issue.

Move Existing Sharepoint Linked Database to a different Sharepoint Site

HenryD — Fri, 03 Apr 2026 13:06:10 GMT

Hi. I have a Sharepoint Linked Database that is working well within our company. We would like to use it within another subsidiary company that operates with its own Name and Sharepoint sites. Could you please assist as i am struggling to do this. Thanks

Access adds brackets to text in quotes in Iif statement

WoodyWhite981 — Thu, 02 Apr 2026 01:25:26 GMT

I have a query of 1 short text field. If the field has the value "NOCOV" I want to return Null, otherwise I want the value in the short text field. The problem is that Access add brackets around "NOCOV" and treats it like a parameter.

I enter:

PRM_PreMedicare_Plan_ID: IIf([PRM Pre-Medicare Plan ID]=“NOCOV”,Null,[PRM Pre-Medicare Plan ID])

The result is:

PRM_PreMedicare_Plan_ID: IIf([PRM Pre-Medicare Plan ID]=[“NOCOV”],Null,[PRM Pre-Medicare Plan ID])

It doesn't matter if I use <> or Like instead of = or Switch instead of IIf. The same problem occurs. I don't know how to prevent Access from adding brackets.

I'm using Access for Office 365 Version 2603.

Tool to compare object in one database with the same object in another database

elkinskckathy — Fri, 27 Mar 2026 14:05:26 GMT

I would like to compare a form in a backup database to the same form in my current database. It is very difficult to use the properties to find differences.