Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: > Conditional Formating Fails

    Two fields. both numbers.

    If Field Value B is Greater than Field value A then field value B is green.

    I have three field value B's that are less than field value A and it still displays and prints green.

    I can't find anything on this.

    Ideas . . . ?

    Thanks Rick

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    mmmm boy I don't do conditional formatting often......

    try explicitly turning green off with an additional statement....

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    It would probably help if we knew what you were using in Conditional Formatting

    With Field B selected, in Conditional Formatting it should be

    Expression Is [Field B] > [Field A]

    then select the formatting you want.

    It should be noted that in order for this to work as you want, Field A and Field B must be defined as Numbers. If they are defined as Text you will get all kinds of seemingly odd results, because Access will be evaluating the ASCII value for the digits rather than the Numeric values.
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Incorrect Assessment

    I discovered he problem.

    It was the underlying query wasn't defining type and the number field was text.

    As soon as that was corrected the problem went away.

    Sure drove me nut though.

    Thanks.

    Rick

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As you've found out, there's a big difference between a field that is all digits and a field that is all numbers! Access treats them differently when sorting or comparing them!

    Glad you got it figured out!

    Good luck with your project!
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

Posting Permissions

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