Recent content by cemmott

Ok yes my code doesn't actually get triggered with real data as the DUMMY is an invalid reference so is never true. But the point was to demo that you can view (in Layout mode) the different colours in the field formatting after doing this. I've since found that you can continue adding further...

I made a form with a text control called 'testing', and put this in the open event... Private Sub Form_Open(Cancel As Integer) Dim fc As FormatCondition, MyControl As control Set MyControl = Me.testing MyControl.FormatConditions.Delete Set fc =...

Hi, this is my first post - just registered so i could post this reply. I've been struggling with this limit of 3 FC's via VBA for a long while, and have discovered a workaround. I'm using Access 2010. By accident i found that i could add more than 3 FCs in one control but got the familiar error...