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

    Unanswered: Conditional formatting Access 2003 report field

    I have in the conditional formatting box . . .

    Field Value is | equal to | "PSPR" Or " PDST"

    Font Blue

    ------------------------------------------

    Not working . . .

    Suggestions?

    Thanks . . . Rick

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Can't do it that way! Instead of 'Field Value Is' You'd have to use

    Expression Is

    Then

    [FieldName] = "PSPR" Or [FieldName] ="PDST"

    Then pick your Formatting. Be sure to enter the actual Field name just like I did, including the Square Brackets:

    [FieldName]

    Linq ;0)>
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

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

    Ding . . .

    Yep . . . you had it right on . . .

    This is what I came up with right after I sent the post.

    Expression= [City]="BD" Or [City]="COA" Or [City]="CTHC" etc. 19 times. Yikes!

    What I was doing originally was expression= | [City]="BD" OR "PDSP" OR "PSPR" etc.

    Thanks Much.

    Rick

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Yikes, indeed!

    Linq ;0)>
    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
  •