Results 1 to 3 of 3
  • Thread Tools
  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. Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 44 Times in 43 Posts
    Use the Expression Is option in conditional formatting. Then put in something like [active]=true.
    Regards
    John



  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
  •