I recently ran into a bug while using FormatConditions in VBA.  I'm using Microsoft Access 2024 64-bit, version 2605, build 16.0.20026.20076, which is dated around May 2026.  This is an age-old bug (from 10-20 years ago) that was supposedly fixed in the years since, as this Devhut article says:

     https://www.devhut.net/access-formatconditions-object-for-each-iteration-is-incorrect/

But I'm getting it right now, and I'm curious to see if others are getting it too in their latest or semi-latest Access builds.

To recreate this bug, create a form, create a textbox called Text1, and put in this procedure in the form's VBA module:

Details

Private Sub Form_Open(Cancel As Integer)
    ' 9/5/26 Created for testing
    
    Dim i As Integer
    Me.Text1.FormatConditions.Delete
    
    For i = 0 To 5
        Me.Text1.FormatConditions.Add acExpression, , "1 = 1"
    Next i
    For i = 0 To 5
        Me.Text1.FormatConditions(i).BackColor = RGB(255, 255, 255)
        Me.Text1.FormatConditions(i).ForeColor = RGB(0, 0, 0)
    Next i
End Sub
Copy

A run-time error will occur at the line that accesses Me.Text1.FormatConditions(3), which is the 4th member of the FormatConditions collection.

The bug is this: VBA can only access up to 3 members, even when there are more than 3 members.

The workaround I found (which isn't mentioned in the Devhut article above) is bizarre: do not use spaces in the format condition's expression.

Instead of using spaces in "1 = 1":  
     Me.Text1.FormatConditions.Add acExpression, , "1 = 1"

Remove the spaces:
     Me.Text1.FormatConditions.Add acExpression, , "1=1"

And there is no more run-time error.

If spaces must be used, such as when using logical operators ("A=B And C=D"), my second workaround is this: enter the format conditions in the form's design mode's UI.  That would also allow you to access past 3 members in VBA.

If anyone could try this out, thank you in advance and please let me know any findings.