Results 1 to 3 of 3
  1. #1
    wes9659 is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Location
    Dover, Ohio
    Posts
    88

    Highlighting Field in Use

    Can anyone explain to me or can refer me to a YouTube link which shows. What properties to set on a form which will allow selected fields on the form to highlight when there selected and return to default color when they are no longer selected. So as you tab thru form the field you are on is highlighted. I hope that makes sense J Thanks Everyone for all your help. I am using Access 2013

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    You can use Conditional Formatting to do this.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Like this, in Form Design View:

    1. Hold down <Shift> and select each Control you want included
    2. Go to the Ribbon - Design Tab - Conditional Formatting
    3. Under Condition 1 select Field Has Focus from the dropdown box
    4. Select the formatting you desire using the BackColor (the paint bucket) and/or ForeColor icon(s)
    5. Click on OK

    You're done.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Highlighting Field Data when Entered
    By EddieN1 in forum Forms
    Replies: 4
    Last Post: 08-15-2013, 08:22 AM
  2. Highlighting Help!!
    By kyleeb in forum Access
    Replies: 13
    Last Post: 01-29-2013, 06:11 PM
  3. Highlighting values in Table
    By lkevinc42036 in forum Access
    Replies: 2
    Last Post: 07-10-2012, 07:58 AM
  4. Highlighting current txtBox
    By SMC in forum Forms
    Replies: 1
    Last Post: 06-21-2012, 07:46 AM
  5. Highlighting Report Data Based on a Condition
    By KramerJ in forum Reports
    Replies: 1
    Last Post: 05-29-2009, 10:27 AM

Tags for this Thread

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