View Single Post
  #4  
Old March 30th, 2010, 04:48 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How can I print form data in a standard letter

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]