Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='joek' post='781468' date='24-Jun-2009 15:40']4) Another form in the same DB with conditional formatting (and many of the same expressions) DOES work![/quote]
    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

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the suggestion. Turns out that a compact and repair did the trick. I'd completely forgotten about it.

    Much appreciated!

    JoeK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •