Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Conditional Formating (2003)

    I have a report with a Start Time control. I want to change the backcolour to grey if it is = or greater than 14:30, but conditional formating doesn't seem to work.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Conditional Formating (2003)

    It would help if you posted the expression you are trying to use for conditional formating. One possibility is that you are trying to deal with the Start Time as a date/time field, and it is a full Date construction where 14:30 is only a Time.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formating (2003)

    You must use #14:30# as value to compare with. In general, you must put # symbols around literal date and time values.

  4. #4
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (2003)

    The time is formated as a Short Time, and I've used the '#', and it's still not working.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formating (2003)

    I fear we'd have to see (a stripped down copy of) the database.

  6. #6
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (2003)

    Here it is.

  7. #7
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (2003)

    Something strange going on. I stripped all the tables etc, that you wouldn't need, and now it's working?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formating (2003)

    I changed one of the start times to 15:00 and it works - see screenshot

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Conditional Formating (2003)

    Don't confuse the formatted display value of a field with the actual data value. Just because a field is formatted as "short time" doesn't mean there isn't a date component in the data. Similarly, for example, just because you've formatted a field as "currency" (which shows only 2 decimal places) doesn't mean that the display you see of $100.33 might not actually be $100.3333!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  10. #10
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formating (2003)

    Is there a way of tracing what could be stopping it from working? Something I removed from the original database to send it to you, must have prevented it from working, as the original doesn't.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formating (2003)

    Start with the original database.
    1. <LI>Make a copy.
      <LI>Remove one item.
      <LI>Test the report.
      <LI>If conditional formatting still doesn't work, go to step 2.
    When conditional formatting works, the item removed last is a likely culprit, although it also can be caused by interaction between several objects.

Posting Permissions

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