Office

  • Office 2003
  • Office
  • All forums
Question

Hide Optional Section link in Print View

Applies To:

I have a form with optional sections. If an optional section is not used, I do not want the "link" (sorry - lacking vocabulary... i.e the link on the form that you would click on to open the optional section) to show up in the Print View. In other words, no evidence of unused optional sections would appear in my print view.

Thanks!

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation
3 People had
this question

Fred Boer

Fred Boer

Was this helpful?

1

Vote

Answer

Here is one way to do what you ask.

In your print view only place the Optional Section inside a Section.

Use conditional formatting on the section so that it is hidden unless the Optional Section "Exists" in the main view.

 

I tested it like this:

Main view: Inserted an Optional Section with a text box inside.

clicked on "Create Print View for this View...".

Inserted a Section.

From Main view copied the Optional Section and pasted it into the Section in the Print View.

The Optional Section was group1 so in the conditional formatting of the Section I set it to "If group1, does not exist, Hide this Control"

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

exemplaris

exemplaris

Was this helpful?

1

Vote

I think with "Print View" you mean File > Preview on your form. That's a view that cannot be controlled (other than by actually hiding said sections). I recommend you use a Report instead.
-Tom. Microsoft Access MVP
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Tom van Stiphout

Community Moderator
Tom van Stiphout MVP
Community Star
-Tom.
Microsoft Access MVP

Was this helpful?

1

Vote

Answer

Here is one way to do what you ask.

In your print view only place the Optional Section inside a Section.

Use conditional formatting on the section so that it is hidden unless the Optional Section "Exists" in the main view.

 

I tested it like this:

Main view: Inserted an Optional Section with a text box inside.

clicked on "Create Print View for this View...".

Inserted a Section.

From Main view copied the Optional Section and pasted it into the Section in the Print View.

The Optional Section was group1 so in the conditional formatting of the Section I set it to "If group1, does not exist, Hide this Control"

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

exemplaris

exemplaris

Was this helpful?

Thanks, belatedly.. I somehow missed that this had been answered.

 

Cheers!

Fred

 

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Fred Boer

Fred Boer

Was this helpful?

Hi Tom! I somehow missed that this question of mine had replies... sorry, and belated thanks! This question relates to an Infopath form - am I right in thinking you thought I was talking about Access?

Cheers!

Fred

 

    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Fred Boer

Fred Boer

Was this helpful?

1

Vote

You bet. We usually talk Access in the Access forum :-)
    • Child exploitation or abuse
    • Harassment or threats
    • Inappropriate/Adult content
    • Nudity
    • Profanity
    • Software piracy
    • SPAM/Advertising
    • Virus/Spyware/Malware danger
    • Other Term of Use or Code of Conduct violation

Tom van Stiphout

Community Moderator
Tom van Stiphout MVP
Community Star
-Tom.
Microsoft Access MVP

Message marked as answers cannot be deleted

To delete this message, first unmark this message as an answer, then delete it.

Reason to remove escalation


Merge

Enter the thread ID of the thread you are merging into


Reply will be posted to a public thread

You are replying to a public portion of this thread. To reply privately, click Cancel, click the Private Messages tab, and Reply on that private message.

Don't show this message again

To report abuse, sign in or continue without signing in

Thank you.

Report abuse

Abuse type:

Details (optional):

Report abuse

Abuse type:

Details (required):
Enter the characters you see (required):
Type the numbers that you see in the picture.
Play audio and type the numbers that you hear.
Show a different picture.

Sign in

Hotmail, Xbox Live, Messenger, or msn accounts will also work.

Don't have one of the above accounts?

Signing in...
This page will automatically update after you are signed in.
If you are having problems, you can close this message and try to connect again.