View Single Post
  #5  
Old March 30th, 2010, 10:05 PM posted to microsoft.public.access.forms
Roger[_22_]
external usenet poster
 
Posts: 9
Default How can I print form data in a standard letter

There's no running text involved, so I will try that. Thanks for your help
... Roger

"John W. Vinson" wrote in message
...
On Tue, 30 Mar 2010 15:39:44 +0200, "Roger" wrote:

I have looked at Kallal's Super Easy Word Merge and it still seems to me
that there must be an easier way of doing it. If I basically copied my
standard letter into an Access Report using the input form fields as the
standard letter fields that vary with each record, can't I simply go via a
control button to the "report" and fill it in with the last record data,
then print it ? ... Roger


That will work, but it's either limited or difficult. It works fine if the
table field data can be put in a fixed textbox on the report; the report
need
not have a box around it, and its CanGrow and CanShrink properties will
let it
expand or contract vertically, but if you're trying to fit a variable
length
name into a paragraph of running text, it's a bit of work.

That is, you can get a paragraph like

Thank you, Pieter , for your help.

by using "Thank you, " in one Label control and ", for your help." in
another,
with a textbox bound to VolunteerName in between; but to get a more
natural
looking output, you must construct a concatenation of constant and
variable
text in a calculated field in the query.
--

John W. Vinson [MVP]