Results 1 to 2 of 2
  1. #1
    olivetwist is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2017
    Posts
    1

    Highlight Search results better


    I have a Split form that shows basic account info on a specific selected account as well as the datasheet view of all accounts below it. Current users enter an account number in a search box and it highlights rows that match in the data sheet. you select the one you want and its details are displayed in the top form. the current matched results are highlighted in a very faint grey overlay. Is there a way change this color to make it darker and stand out more? if the data sheet has alternate colored rows it can be hard to find the correct entry.

    Thank you in advance.

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,421
    I assume there is no subform.
    Open the form in datasheet view, click on a left textbox and use conditional formatting in an expression.
    In the dropdown, "Field Has Focus", then set background color to whatever you would like.

    This hasn't been a problem for me unless there is only one column in the datasheet. If there are multiple columns, the unselected columns in the row would have a distinctive contrast without using conditional formatting.
    Last edited by davegri; 06-08-2017 at 04:40 PM. Reason: clarification multiple columns

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

Similar Threads

  1. Highlight Duplicate Values in Query Results
    By TJ1010F in forum Queries
    Replies: 3
    Last Post: 06-21-2015, 05:51 PM
  2. Highlight key search result
    By uronmapu in forum Access
    Replies: 28
    Last Post: 06-17-2012, 09:32 AM
  3. Replies: 12
    Last Post: 06-08-2012, 02:37 AM
  4. how to highlight search keywords in results form?
    By Absolute_Beginner in forum Forms
    Replies: 2
    Last Post: 08-22-2011, 04:52 AM
  5. Replies: 0
    Last Post: 10-16-2008, 02:39 PM

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