Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013

    Red face Unanswered: Conditional Formatting

    I am having trouble creating a conditional format on a form. I want to look at the value of one field and based on that value change the display of another field on the same form. I cannot get it to work. I am using Access 2013. Can anyone help me? Thanks in advance

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    You haven't really given us much to go on, but in general you'd go to Conditional Formatting for the Control you want to format, then under Condition1 select 'Expression Is,' and in the next box enter the condition. In CF you refer to the Controls by surrounding the name with Square Brackets, so it'd be:

    Expression Is

    [ControlName] = "Whatever Value"

    or if it's Numeric

    [ControlName] = n

    Then of course, select your desired formatting.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    May 2013
    You are right, the devil is in the details. I identified my problem, I was using the wrong value in the expression. The field that I was evaluating was a lookup from another table. Thanks for responding

Posting Permissions

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