Unanswered: How to copy only data from a record to clipboard or Word?
I have made a simple database for our clients and contactpersons.
What i want to do now is making some sort of label for a envelop or
to be copied to the clipboard for easy pasting in word files or something.
For example it want the following format:
How can i do that? I tried to copy a selected record and then paste it into Word but then i also get the field names too.
I only want to copy the data from the selected record.
Any help appreciated, thx!
Thx for the quick reply.
I already tried the envelop labels but that is not exactly what i need.
I have looked at your Clipboard function and came up with another idea.
I just made a very simple form with just one textbox.
Now i just want to place a few lines in the textbox and i used the following code :
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form1_Click
Dim TmpSting As String
TextCPers = "Bedrijf : " & .[bedrijf] & Chr(13) & _
"Afdeling : " & .[Afdeling] & Chr(13)
This seems to work fine exept for the carriage return Chr(13).
In the output i see a strange character instead of a carriage return.
Any idea how i can get a carriage return i a textbox ?