Results 1 to 5 of 5
  1. #1
    joe55555 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    24

    how can i highlight a selected row in form?

    hello, i have a big access file with forms macros and vba.



    in one form i have 4 subforms
    in one of the 4 sub forms i have a list of more than 100 records (rows)

    and each row has many controls like text boxes, labels, ....

    when i click on any row i see a small black arrow on the left of each row designing the record i am in.

    so i want to highlight the record i select
    and if it is possible i want this highlight to show no matter on which control of the row i click on because i have many and the user may click every time a different control.

    thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    Sorry, Access doesn't have that behavior, at least not intrinsically. I doubt it can be done programmatically.

    If form in Datasheet view, clicking on the RecordSelector will select entire record but clicking in a field selects only that field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I have done something like this.... Have to add a Boolean field to the table, then some code and conditional formatting.

    How close is this?? (see attached mdb - A2000 format)
    Last edited by ssanfu; 08-27-2013 at 03:30 PM. Reason: spelling

  4. #4
    joe55555 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    24
    ssanfu

    that's exactly what i am looking for thank you very much for your help

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Excellent.......

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

Similar Threads

  1. Replies: 5
    Last Post: 07-09-2013, 11:16 AM
  2. Highlight mandatory controls on a form tab on exit
    By thebionicredneck2003 in forum Forms
    Replies: 1
    Last Post: 05-15-2013, 08:28 AM
  3. Replies: 3
    Last Post: 04-22-2013, 06:08 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