Print record w/o background?

  • Thread starter Thread starter StargateFanFromWork
  • Start date Start date
S

StargateFanFromWork

When we're in a form in an Access db, not a report, is there a way to print
the record we have up on the screen _without_ the background; a
printer-friendly version of that record, as it were? And, if so, is there a
way to code this into a button onto the main form interface so that the
users can do this easily? TIA.
 
Douglas J. Steele said:
Forms aren't really intended to be printed: that's what reports are for.
Click to expand...

Of course, and that's understood, but when you need to print _one_ record, a
report for that one record is a bit much. I have a screen capture program
which takes care of things for me, but the idea is to make things easier for
the user.

So my question still stands. If it can't be done and they have to print out
one record onto 3 pages onto all that background that shows on the form, so
be it. Just wanted to make sure.

Thanks.
 
Why is a report for one record too much? It's trivial to save a form as a
report (from the database window, right-click on the form and select the
appropriate "Save as" option), and using the OpenReport method (in the
OnClick event of your button), you can pass an appropriate Where clause to
have the report display as many or as few records as you like.

Unless all of your users have the same screen capture program, it's going to
be difficult to automate that part. You could probably add code to toggle
the background on and off before capturing the form's image, but why go to
that trouble?
 
Back
Top