Results 1 to 2 of 2
  1. #1
    mlawson6128 is offline Novice
    Windows XP Access 2002
    Join Date
    Mar 2011
    Posts
    5

    Conditional Formating (Report Field)


    Access allows you to conduct conditional formatting on a report, or form field. The unfortunate part is that they only allow 3 conditional formats. I am unfortunatly not a programmer, and wondered if anyone could provide me with a simple code to add as many conditional formats. I am only looking to change the "Back Color". For instantce; If the filed says "RED" I would like the back color to be RED, and so on. I need to be able to add as many colors as I want. Can anyone help?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It isn't too tough. You'd use the format event of the section containing the control you want to format (typically the detail section). Test the value of the control with Select/Case and set the back color property of the control as appropriate. I've played with a control in design view to figure out the numeric equivalents of the colors I want to use.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. formating field
    By slimjen in forum Access
    Replies: 9
    Last Post: 01-11-2011, 04:46 PM
  2. Conditional calculated field.
    By ser01 in forum Queries
    Replies: 3
    Last Post: 01-03-2011, 02:16 PM
  3. Conditional Formating In A Report
    By cadsvc in forum Reports
    Replies: 11
    Last Post: 11-02-2010, 04:47 PM
  4. Conditional Formating in pivot table
    By Tina in forum Access
    Replies: 0
    Last Post: 08-25-2010, 10:38 AM
  5. report formating/sorting problem
    By bill4364 in forum Reports
    Replies: 1
    Last Post: 02-19-2010, 08:15 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums