Hi,
I have a Form that opens up my database using Autoexec. I have some simple, basic conditional formatting on some of the fields. If field = 0 then the backfill is in green, if the field is >= 1 then the backfill is red.
This has been working fine with no problems in an Access 2007 Database.
I have just renamed the file and moved it to another folder and now the conditional formatting no longer works, but in Design View it is still there. I have seen this before when I saved a database to a memory stick and - although the Database worked - the conditional formatting stopped. I wondered if it might be a problem with the Trust Centre - Trusted Locations? I have added my new folder to the list but it doesn't seem to have made any difference.
Can anybody explain why the conditional formatting would suddenly stop functioning?
I am about to hand this database over to someone else, I've just built a user guide and now the screenshots no longer match the database. Which is quite infuriating!
Thanks,
Oz