Results 1 to 3 of 3
  1. #1
    withk001 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2015
    Posts
    3

    Conditional Formatting on a Form with a Drop Down list

    Hi All.



    I have produced a form where each question has a drop down (combo box, value list) with either Yes or No to be chosen. I want the box to be highlight green if Yes and red if No (as shown on the screen shot), however when I save and go into the form it isn't working?

    Conditional formatting is showing as: Value=Yes Format: Green highlight.

    Any ideas?

    Thanks,

    Kirsty

  2. #2
    JamesDeckert is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    I don't see the screen shot.
    Is the combobox bound to a field in a table?
    How is the field in the table defined? Boolean? Text?

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    The fact that the Combobox is populated via a Value List means, I'm pretty sure, that the Value is going to be String/Text, so try

    "Yes"

    instead of simply

    Yes

    Linq ;0)>

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

Similar Threads

  1. Replies: 16
    Last Post: 12-02-2013, 06:20 AM
  2. Replies: 6
    Last Post: 05-26-2013, 09:10 PM
  3. Replies: 2
    Last Post: 12-22-2012, 07:49 AM
  4. Replies: 7
    Last Post: 10-01-2012, 07:59 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