Print data from form to data fields on template

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

Guest

I'm trying to enter data on a form, then have that data populate fields on a
form that is fed into the printer.

I think I probably need to build VBA language to print in defined areas and
transfer the form data to variables that can be placed exactly where they are
needed.

Printing straight from the form leaves awkward spaces after names of cities
or people due to their variable string lenghts.

Any ideas? I'm dabbling in small-time develpment after taking Jr.College
classes in into to VBA and programming in Access.
Thank you
Karl
 
You should use a report rather than a form. You can place field/text boxes
almost anywhere required.
 
When using a report, while that works, there are sometimes long spaces
between fields. The text box is long enough to handle very long names, but if
the names are short, the next field starts a fair distance from the one
before.

I want it to look like: Steve Smith
rather than: Steve Smith
Is there a way to get rid of that uncomfortable spacing?

Thank you for your help,
Karl
 
I want it to look like: Steve Smith
rather than: Steve Smith
Click to expand...



Make the Controlsource of the text box

= FName & " " & LName

so it's all one

Hope that helps


Tim F
 
use
= Trim(FName) & " " & Trim(LName)
to remove extra blanks before and after the names so you will get
Steve Smith.
 
Back
Top