Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2014
    Posts
    3

    Unanswered: Conditional formating

    In my Access forms, i display data by month wise; and i want to give the conditional formating with two condition;
    If date of today is greater than target date for that month and if got value more than 0 - Red color
    If date of today is lesser than target date for that month and if got value more than 0 - green color
    Target date for every month in available in a separate table.
    how to do this?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    perform a join to the table that contains the target and then access the value within the report
    or
    you may be able touse a dlookup in a conditional format, but if woudl almost certainly be a performance pig

    bear in mind you can develop your own far more flexible rules for formatting in the detail on format event. unlike the inbuilt conditional formatting which can be very restrictive you can do virtually wahtever you want
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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