Specify a different printer for a report

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

Is there a way to specify in VB the printer to which a report is to be
printed?

I have a program that is working great. The report that is generated is
fairly complex and has a significant amount of detail. The users have
recently discovered a shortcoming that I am trying to address.

The report is setup to print on multiple pre-formatted template pages. The
detail of the report is printed on a dot-matrix printed on these
pre-formatted triplicate pages. As much as I have wanted to move away from
this method, it has been decided that this is the best route.

HERE IS THE PROBLEM:
On each report, there is a notes section. The users can type whatever they
want in this to facilitate the report information. On the report, the notes
section is a fairly large box in the footer.

The users are now entering enough information that there is not enough space
to print the entire note (sometime the notes alone can be a whole page). The
notes field in the footer does not have the ability to continue over to
additional paged ( I am pretty sure of this).

I was planning to do the following:

When the report is printed, the system will test the length of the notes
section. If it is long enough, it will capture the notes section and send it
as a separate report to a separate printer (because it does not want to
print the notes on a dot-matrix printer).

What might the syntax be in VB to call a report to print to a specific
printer (rather than the default?)

Does anyone have any ideas about this?

Thanks,

Stephen
 
Back
Top