copying from text control on access form

[janith]

Hi,

This might sound weird but have a question around copying a text value from a form control to another application. For some reason it's becomes hard to copy a value from text box control. Any reasons why this is happening and how can I resolve this issue. Please help???

 

[Gasman]

Hi,

This might sound weird but have a question around copying a text value from a form control to another application. For some reason it's becomes hard to copy a value from text box control. Any reasons why this is happening and how can I resolve this issue. Please help???

Well I was thinking you'd copy it to the clipboard with some vba code and a library reference, but Access actually has a command to do it

https://msdn.microsoft.com/en-us/library/office/ff192913.aspx

I think the key is you have to set focus to the control for this method?

I seem to recall I used something similar to below in the past and it might have been in Excel as well. This way you can just select whatever text you want without having to set focus?

http://stackoverflow.com/questions/14219455/excel-vba-code-to-copy-a-specific-string-to-clipboard

 

[janith]

Hi,

Sorry for not being clear enough.. What I meant was.. When I try to copy the text from the text box control. It's takes two or three attempts to do that.. Not sure what the problem is..