Printing a section of a page if a condition is met

Printing a section of a page if a condition is met - Word 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elle0612 - 16 Aug 2006 22:03 GMT

Hi

Is it possible to set one half of an A4 page for printing if a certain
condition is met - ie checkbox not checked, and print the whole page if it is
checked.

The reason being I have two sets of labels on one sheet, if I need the two
sets I can tick the box and have the two sets printed, else I only print the
one set.

I have two text boxes to take information from a userform into the document
(pre-prepared full A4 page of labels with bookmarks to take the textbox
information - distributed into one set of labels in both halves).

Sometimes only one set will need to be done, sometimes two.

Any ideas how to go about this.

Thanks

Reply to this Message

Jezebel - 16 Aug 2006 22:24 GMT

There's no direct method. You could set font.hidden = true/false for the
optional labels.

> Hi
>
[quoted text clipped - 18 lines]
>
> Thanks

Reply to this Message

elle0612 - 16 Aug 2006 22:49 GMT

Hi

Thanks for that. That would work if the only text on the labels was from
the textboxes, but as I said I have partly prepared the label document with
some text beforehand, the text from the textboxes will end up added at the
bookmark points. What I want to do in a way is mask half of the page
completely if a condition is met, and unmask it if another one is met.

Perhaps selecting half of the label table to print if one condition is met,
and unselecting to print all if another is met. But I'm not sure how to do
this.

thanks

> There's no direct method. You could set font.hidden = true/false for the
> optional labels.
[quoted text clipped - 21 lines]
> >
> > Thanks

Reply to this Message

elle0612 - 17 Aug 2006 06:45 GMT

Hello

Another idea I've had is to add a second page of labels to the document,
this time with only one part completed. And if the check box is ticked, then
the page with all labels on would be printed else the page with only half
would be printed.

How do you specify which page you want to print in VBA. It will be
ActiveDocument.something??? for the default printer, and something like
page(1) or page(2) I suppose. Hope someone can help because I feel I'm
getting somewhere now.

Thanks

> Hi
>
[quoted text clipped - 35 lines]
> > >
> > > Thanks

Reply to this Message

elle0612 - 19 Aug 2006 23:07 GMT

In the end I got around the problem by closing the ActiveDocument with the
two sets of labels and opening another from another file with a single set.
Works fine.

> Hello
>
[quoted text clipped - 49 lines]
> > > >
> > > > Thanks

Reply to this Message