Making a Form Letter

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

Guest

I'm trying to make a form letter via a report

I need it to be like

Dat

FirstName LastNam
Stree
City, State ZI

Dear FirstName

so on and so on...

Obviously, since the fields are different lengths, I can't use presized lengths for the fields. I tried typing the whole thing in one text box and using the =Trim([fieldname]) for the fields I need filled in, but i kept getting syntax errors if I did more than one trim expression. What am I doing wrong, or is there an easier way to do this

Thanks

Kyle
 
Create text boxes with control sources like:
=FirstName & " " & LastName
=City & ", " & State & " " Zip
="Dear " & FirstName & ":"

Make sure the name of the controls are not the same as field names.


--
Duane Hookom
MS Access MVP


Kyle said:
I'm trying to make a form letter via a report.

I need it to be like:

Date

FirstName LastName
Street
City, State ZIP

Dear FirstName:

so on and so on....

Obviously, since the fields are different lengths, I can't use presized
Click to expand...
lengths for the fields. I tried typing the whole thing in one text box and
using the =Trim([fieldname]) for the fields I need filled in, but i kept
getting syntax errors if I did more than one trim expression. What am I
doing wrong, or is there an easier way to do this?
 
Back
Top