Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2010
    Location
    New Jersey
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    access 07 conditional formating reports

    Hi
    How do I conditionally format a field for printing based on the value of another field in the same record. I need to set the backcolor of the field to yellow if it is an active account.
    Thanks
    Cathy

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Use the Expression Is option in conditional formatting. Then put in something like [active]=true.
    Regards
    John



  3. #3
    New Lounger
    Join Date
    Sep 2010
    Location
    New Jersey
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    THANKS!! I am used to earlier versions of Access, this is so easy..

Posting Permissions

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