Results 1 to 4 of 4
  1. #1
    adillpickle is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    13

    Conditional Formatting in a Access Form

    I have a field in my Access form that has multiple answers that can be selected (see attached screen shot). When one of those answers is selected by users of the form, I would like to have the field turn a specific color. Is there an expression I can write that would allow me to do that, even if other answers are selected as well?
    Click image for larger version. 

Name:	Capture.JPG 
Views:	12 
Size:	10.3 KB 
ID:	23509

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That looks like a Multi-Valued Lookup field. Is it?

  3. #3
    adillpickle is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    13
    Yes, I believe it is. It's pulling from a table that was created.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I don't have a solution but now we have a little more information about your form.

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

Similar Threads

  1. Replies: 4
    Last Post: 09-25-2015, 07:28 AM
  2. Access Reports - Conditional Formatting
    By harpreett.singhh@gmail.co in forum Access
    Replies: 3
    Last Post: 08-07-2014, 02:38 PM
  3. Conditional Formatting in Access
    By Triland in forum Access
    Replies: 29
    Last Post: 01-18-2013, 01:00 PM
  4. Access Conditional formatting
    By mailboy in forum Access
    Replies: 1
    Last Post: 12-17-2011, 01:34 AM
  5. Conditional formatting on form
    By ngruson in forum Forms
    Replies: 11
    Last Post: 09-17-2010, 12:15 PM

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