Select entire text in Text box

[Steven R via AccessMonster.com]

I know this can be done by tabbing into a field or double-clicking (carefully)
, but my users are going to be frequently selecting text to copy/paste - it
would be nice if the could click a button to select all the text in the field
- I know send keys doesn't work real well, but it would be nice if there was
a way I could also do CTRL+C programmatically in VBA

 

[Ken Snell [MVP]]

From a post by Douglas Steele, ACCESS MVP:
-------------------

Take a look at http://support.microsoft.com/?id=138909

Once you've saved all that code into a new module (make sure you don't name
the module ClipBoard_SetData!), you'd simply need to put
ClipBoard_SetData(strNumbers) in your code somewhere.

http://support.microsoft.com/?id=138910 shows similar code for reading from
the clipboard.

 

[Steven R via AccessMonster.com]

Ken,
Thanks !

From a post by Douglas Steele, ACCESS MVP:
-------------------

Take a look at http://support.microsoft.com/?id=138909

Once you've saved all that code into a new module (make sure you don't name
the module ClipBoard_SetData!), you'd simply need to put
ClipBoard_SetData(strNumbers) in your code somewhere.

http://support.microsoft.com/?id=138910 shows similar code for reading from
the clipboard.
-------------------

You then could run code via button click event that would use the
ClipBoard_SetData procedure to read the .Value of the textbox and write it
to the clipboard.

I know this can be done by tabbing into a field or double-clicking
(carefully)

[quoted text clipped - 5 lines]

was
a way I could also do CTRL+C programmatically in VBA