Hard Return?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Folks at my company would like to be able to cut and paste a name and address
from the database to a letter.
That doesn't seem to work from a report, but can be done from a form.

What would be ideal would be if I could write a query that would combine the
name and the address together, with hard returns in the coding so that the
result would be one field. Is this possible?

Is there a better way?

Thanks.
 
You can easily create a string from the name and address fields, using
vbCrLf for the hard returns. From memory, I think Word uses Chr(11) for a
line-feed that is not a paragraph break.

Once you have your string, you need an API call to stuff it into the
clipboard. Copy the code in this article:
Copy variables/control contents to memory
at:
http://www.mvps.org/access/api/api0049.htm
 
Back
Top