Conditional Formatting Disappears

Topic

New Reply

I have a form with conditional formatting based on dates, status selection from a combo box and other things. I open the DB and suddenly the conditional formatting doesn’t appear.

1) The conditional formatting expressions are still there
2) I didn’t change anything in the DB since the last time I looked at it – and it was working fine then
3) I shut down Access, restarted it and all of that, which didn’t work
4) Another form in the same DB with conditional formatting (and many of the same expressions) DOES work!

Any ideas on what happened and how to prevent the amazing disappearing conditional formatting trick?

Thanks,

JoeK

Reply | Quote

Replies

4) Another form in the same DB with conditional formatting (and many of the same expressions) DOES work!

Joe,

I’m not one of the experts here, but often when something like this happens (and it has happened to me), the usual thought is that the form (or database) has gotten corrupt or something.

The usual suggestions are to create a fresh database, and drag all your forms, reports, etc. to that new database, or “decompile and recompile” (just search on “decompile” in threads here, and you will find lots of info), or, sometimes it just helps to plain rebuild the form in question. I have re-created a report and form or two, and also dragged stuff into a new, fresh database (and had the issue resolved). De-compiling gets rid of code that you may not be able to see, but which just didn’t get removed during the process of editing and re-editing, etc.

Hope this helps.

thx
Pat

Reply | Quote

Thanks for the suggestion. Turns out that a compact and repair did the trick. I’d completely forgotten about it.

Much appreciated!

JoeK

Reply | Quote