Copy textbox to clipboard

[Cryptographic_ICE]

Hello,

I have an access 2003 report that has a text box called text2. I would
like to make it when the report is opened text2 is copied to the
clipboard. What is the best way to do this? I have tried writing an
event for on open (VBA code). The reason I'm doing this is because I
have to print the reports to a PDF and the names are really long. So
if anyone knows how to automatically output them as PDF (the filename
needs to be the same as text2) Any help is appreciated.

 

[Arvin Meyer [MVP]]

You might try Stephen Lebans code at:

http://www.lebans.com/reporttopdf.htm

or use Win2PDF which has sample code on how to automatically save a pdf:

http://www.win2pdf.com