Supress blank text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Olduke - 05 Jan 2008 18:59 GMT

Using Word 2003 with Windows XP
My VBA skills - Fair

I have a template which I inherited. It is a monthly activity report for
off site workers. The template contains 6 areas for acitivity reporting.
Each area has 25 entry possiblities.

In the first area - Meeetings - off site employees are required to report
the meetings they attended. There is MeetingDate1, followed by
MeetingReport1 all the way down to MeetingDate25 and MeetingReport25.

What I would like to do is find some way of supressing any of the Meeting
fields that are blank when the report prints. Right now, the report prints
over 5 pages but most of the time there may be only 10-15 lines of actual
text.

Reply to this Message

David Sisson - 06 Jan 2008 01:48 GMT

> Using Word 2003 with Windows XP
> My VBA skills - Fair
>
> I have a template which I inherited.

I hope that means you can add some code to it.

You could hide the text.

If ActiveDocument.FormFields("Report1").Result = "" Then
ActiveDocument.Sections(2).Range.Font.Hidden = True
End If

Then when you printout, only the visible will printout.

If you want to keep the original intact, just close without saving.

Reply to this Message

Olduke - 06 Jan 2008 03:41 GMT

Thank you David, I'll give it a try.
The template is designed to open as a document, so it should be OK
Glen

> > Using Word 2003 with Windows XP
> > My VBA skills - Fair
[quoted text clipped - 12 lines]
>
> If you want to keep the original intact, just close without saving.

Reply to this Message