I am experiencing an odd problem with conditional formatting. I have an Access database in mdb format that my client has been using for years in Access 2000 & 2003. When the client upgraded to Access 2007 on his machine, the conditional formatting in the same mdb file no longer works. I tried deleting the conditional format and recreating it from scratch, and it seems to work. Has anyone else experienced this? Is recreating the conditional format the only workaround?
Upon implementing the workaround, I found that users running Access 2003 cannot open the form at all, so it's not even a very good workaround. If anyone has any experience with this, I would really appreciate the input.