Results 1 to 5 of 5
  1. #1
    KRM240 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2014
    Posts
    1

    How to Select entire cell contents in a form?


    For the form I have, when I tab, the entire next cell/field contents is selected - which is what I would like to happen when I click on a different field.
    How do I select the entire cell contents when you click on afield?
    Using Access 2013
    Many thanks in advance...

  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,632
    Requires VBA. Example:

    Private Sub cbxStrengthUnits_Enter()
    Me.cbxStrengthUnits.SelLength = Len(Nz(Me.cbxStrengthUnits, ""))
    Me.cbxStrengthUnits.Dropdown
    End Sub
    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
    If the control has only one word in it, you can double click the control and the entire word will be selected.
    If the control has multiple words (ex: control for Part Number has "Oxygen Sensor"), double clicking only selects the last word or the word clicked on.

    Otherwise, as June said, will require code.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I think there is a global setting in Access that determines if all of the text is selected or if just one word. Not sure if it is associated with click or associated with tabbing into a control. I believe it is Client settings.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    The only relevant Client Settings property I see is Behavior Entering Field. However, doesn't work when clicking into control.
    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.

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

Similar Threads

  1. Expand entire row not just single cell in a Report
    By CityOfKalamazoo in forum Reports
    Replies: 2
    Last Post: 07-28-2016, 09:22 AM
  2. Delete Contents of worksheet before export - xlWSh.Cells.Select
    By allenjasonbrown@gmail.com in forum Programming
    Replies: 1
    Last Post: 10-14-2012, 10:38 PM
  3. Replies: 5
    Last Post: 04-18-2012, 12:04 PM
  4. Select contents of a field on click?
    By anoob in forum Access
    Replies: 7
    Last Post: 03-01-2011, 07:59 AM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 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