Results 1 to 4 of 4
  1. #1
    BobW2961 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    16

    now to set a field to be highlighted

    what is vba way of setting a field on a form to be highlighted?


    by highlighted I mean that whatever information is in that field is highlighted or reversed and ready to be typed over. Same as if you right click and drag across the field contents.
    I would like to be able to set a field to that state.

    Thanks

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    try Me.NameOfControl.SetFocus
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    or perhaps you need to use conditional formatting, setting the back and/or forecolour as required when the control has the focus

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I think poster wants the effect of having the control contents selected, as if you dragged across the contents, although I figured that 'left click' is what was really meant. In such a case, whatever user begins typing will over-write the contents without having to use mouse to pre-select the contents.
    by highlighted I mean that whatever information is in that field is highlighted or reversed and ready to be typed over. Same as if you right click and drag across the field contents.

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

Similar Threads

  1. Replies: 6
    Last Post: 09-03-2015, 01:27 PM
  2. Replies: 2
    Last Post: 10-22-2014, 11:37 AM
  3. Replies: 17
    Last Post: 03-16-2014, 10:52 PM
  4. Exporting to Excel - All Worksheets Highlighted
    By kristyspdx in forum Import/Export Data
    Replies: 3
    Last Post: 02-26-2013, 05:42 PM
  5. Rainbow color effect on textbox highlighted text
    By DanielHofer in forum Forms
    Replies: 1
    Last Post: 08-31-2011, 08:14 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