Results 1 to 3 of 3
  1. #1
    gutenberg is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2016
    Posts
    31

    Highlighting the background of textboxes of a particular word

    Is there a way to highlight the background of textboxes of a particular word on a form? I want to highlight the background of every textbox that contains the word "Alabama."



    Click image for larger version. 

Name:	Form View.jpg 
Views:	12 
Size:	223.6 KB 
ID:	26114

    Click image for larger version. 

Name:	Design View.jpg 
Views:	11 
Size:	132.5 KB 
ID:	26115

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Your options are limited when dealing with a continuous form. Have you tried, while in design view of your form, right clicking the textbox control and applying Conditional Formatting?

  3. #3
    gutenberg is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2016
    Posts
    31
    Yes. I clicked on the Conditional option on theformatting ribbon. Selected "Expression is" and typed:
    [Desc2] LIKE"*Alabama*"

    and it worked. Problem solved.

    I was using the Field value is equal to and it wasn't working.

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

Similar Threads

  1. Highlighting data changed
    By pharrison74 in forum Reports
    Replies: 3
    Last Post: 03-04-2016, 10:13 AM
  2. Highlighting Field in Use
    By wes9659 in forum Forms
    Replies: 2
    Last Post: 01-31-2015, 12:28 PM
  3. Highlighting Help!!
    By kyleeb in forum Access
    Replies: 13
    Last Post: 01-29-2013, 06:11 PM
  4. Highlighting values in Table
    By lkevinc42036 in forum Access
    Replies: 2
    Last Post: 07-10-2012, 07:58 AM
  5. Highlighting current txtBox
    By SMC in forum Forms
    Replies: 1
    Last Post: 06-21-2012, 07:46 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