Printing memo data from a form

  • Thread starter Thread starter Martin Higgs
  • Start date Start date
M

Martin Higgs

I have a form which contains a memo field which may require more than one
page to print. I can only get my printer to print out what is almost a
screen shot of the page. How can I set up a command button which will print
out the form with all the data from the memo field?
 
Martin,

You will run across that problem when trying to print forms. Forms are
desinged to be used like menus (inputting data), reports are designed for
printing. Create a report and set the field to Can Grow = Yes.
 
Gina
Thanks. I tried that in a report and sadly, it didn't work unless I knew in
advance that it would take multiple pages and directed the printer to print
pages 1096 and 1097 for example. There has to be a way to get it to
automatically print the second page (or third,etc.)
I have a database of almost 2000 people for whom we are entering
information. I have the memo field in both the form and in a report, but
need a button (or fairly simple method) which will command the printer to
print only all pages needed in the particular report which matches the
record for the person we want. Any ideas would be appreciated.
 
Martin,

Am I understanding you just want to print memos (report) for a particular
person? If this is so. Is the UserID numeric or text and does the memo
field have a unique ID?
 
Okay but what about the memo field does it have a unique ID (text or
numeric) or do you want ALL the memos to show from each user? This will
preview the report to show ALL memos per user but if you want one memo per
one user then you need the to add the memo ID on to the end.

DoCmd.OpenReport "YourReportName", acPreview, , "[YourUserIDFieldName]=" &
Me.NameOnForm
 
Back
Top