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

    Unanswered: Conditional Format in Report Field

    I have a report field [SellingName] that will have thousands of different office names in it.

    I'm using the Conditional Formating window for the field so as to print the font in blue when the condetion is met.

    Field Value Is equal to "COLDWELL BANKER NRT*"

    This fails.

    I understand this means exactly but how do I make it works as if there were a wild card after NRT*?
    ie,

    COLDWELL BANKER NRT TUS or
    COLDWELL BANKER NRT SA or
    COLDWELL BANKER NRT WTM, etc.

    Any suggestions?

    Thanks . . . Rick

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    502
    Yea . . . I figuered it out!

    I used Field Valus Is between COLDWELL BANKER NRS and COLDWELL BANKER NRU

    Whew!

    There's one for ya.

    Rick

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Alternatively, you could have used Expression Is with:

    [SellingName] Like "COLDWELL BANKER NRT*"

    which in certain circumstances would be more accurate.
    Paul

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    In all truth, you should be using the MLS number for that office if at possible...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

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

    Forced to enter a value . . ?

    [SellingName] Like "COLDWELL BANKER NRT*"

    This asked me to enter a value?
    Rick

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Don't know what the MLS number is that Teddy mentioned, but odds are he's right.

    Not sure what to say, if the field name is right (and you changed to Expression Is). I tested in a db and it worked fine.
    Paul

Posting Permissions

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