Results 1 to 3 of 3
  1. 11-21-2012, 05:20 PM #1
    baileysw
    baileysw is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    1

    Post Conditional Formatting Problem

    I'm trying to use conditional formatting to trigger on text within a textbox in a report.
    If any of the text has the following: "(H)"
    i.e. CAM 01-09(H)
    Then the text background would be red and font would be yellow.



    The problem is when I use the Conditional Formating GUI it does not allow me to look for this correctly.
    Any help in advance would be highly appreciated.

    Scott
    Reply With Quote Reply With Quote
  2. 11-21-2012, 06:04 PM #2
    orange's Avatar
    orange
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    More info please (details).
    it does not allow me to look for this correctly
    doesn't help the readers.
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  3. 11-21-2012, 06:23 PM #3
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    You should be able to use Expression Is and the InStr() function to test for that string.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Conditional Formatting
    By riaarora in forum Access
    Replies: 6
    Last Post: 09-03-2012, 05:58 AM
  2. Conditional Formatting
    By bellevue in forum Forms
    Replies: 4
    Last Post: 05-17-2012, 06:03 AM
  3. Conditional Formatting
    By ccordner in forum Reports
    Replies: 6
    Last Post: 01-09-2012, 04:12 PM
  4. Conditional Formatting
    By Paul H in forum Reports
    Replies: 3
    Last Post: 11-07-2011, 11:59 AM
  5. Conditional Formatting Problem
    By DanKoz in forum Access
    Replies: 6
    Last Post: 10-23-2011, 12:57 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums