How do I print a template with only selected checkboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SharksFan - 23 Oct 2006 23:15 GMT

I am creating a template with checkboxes for selected criteria. Once all of
the criteria (checkboxes) are selected, I want to print the document and only
include the items that have been selected. Can this be done?

Reply to this Message

Dawn Crosier, MVP - 23 Oct 2006 23:40 GMT

You do have the option to print the data only. Tools, Options, Print, Data
Only. I'm not sure that is what you want, but if it is not, then I might
try changing the font of the unselected items to White text on a white
background. Since you are working in VBA, you could do that on the OnExit
event of one of your formfields.

Signature

Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"

This message was posted to a newsgroup, Please post replies and questions
to the group so that others can learn as well.

>I am creating a template with checkboxes for selected criteria. Once all of
> the criteria (checkboxes) are selected, I want to print the document and
> only
> include the items that have been selected. Can this be done?

Reply to this Message

Jezebel - 23 Oct 2006 23:41 GMT

Identify each of your items by bookmark; then for each item you don't want,
set [Bookmark].Range.Font.Hidden = true

Reply to this Message