Results 1 to 3 of 3
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839

    Change Text color and/or background color

    I have a Long text control out putting to a report as rich text format named [ChangeRequested]. I would like to change the color of a text based on a key word.



    Examples in Text:

    Green Text
    Red text
    Brown text

    I know I can activate using the Conditional Formatting using Expression is [ChangeRequested] like "* Red text *" then change the settings for the text. Simple. What I would like to do is to be able to change the color only for the words "Red text" and keep all other characters the same black text.

    Examples in Background color change

    Shade Blue
    Shade red
    Shade Yellow
    Shade Green

    I know I can activate using the Conditional Formatting using Expression is [ChangeRequested] like "* Shade Green *" then change the settings for the background. Same as above, I only want the key words to have the background change. It may be called highlighting.

    How would I go about this? I think it might be easier if its in VBA. Suggestions please.

    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    VBA not required, have a look at this post for how to do it

    https://www.access-programmers.co.uk...d.php?t=290820

  3. #3
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    Thanks
    I figured I'd be lazy and format as I go. There isn't that much data to update.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-29-2015, 07:38 AM
  2. Replies: 4
    Last Post: 10-28-2014, 09:51 AM
  3. Replies: 2
    Last Post: 06-01-2014, 12:05 PM
  4. Replies: 3
    Last Post: 01-01-2014, 11:21 PM
  5. Change Row Background Color Programmatically
    By sales@4bco.com in forum Programming
    Replies: 2
    Last Post: 10-25-2009, 11:17 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
  •  
Other Forums: Microsoft Office Forums