Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / October 2006

Tip: Looking for answers? Try searching our database.

Questionnaire's - hiding questions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chris - 24 Oct 2006 08:55 GMT
I am trying to understand if it is possible to create a questionnaire where
questions are hidden until a certain answer is given.

E.g. Answer 'No' to question 1, then question 1b opens up that asks a
further question.

I presume some sort of macro would be needed for this? Any help much
appreciated.
Dian D. Chapman, MVP - 24 Oct 2006 19:49 GMT
Yes, it's POSSIBLE. But it'll depend on how to design up your template
as to how it would work. So providing a lot of details would be
difficult.

Example...first you would have a checkbox or dropdown for the
question. If the user clicks or chooses YES, then you could either
have text that has been hidden and you could unhide it. But since
users can set hide/unhide settings on their own, you'd have to also
control the dialog box for that option...which can be done, but is
complex if you're not good with VBA.

So an alternative would be to insert bookmarks in various locations
and then create more of the form as AutoText. When an answer is YES,
you'd move to the bookmarked location for that answer and insert the
autotext that contains the rest of the form. Of you could also use
separate doc files with the "parts" and insert those into the needed
bookmarks.

I'd suggest you start by checking some of my free AutoForm tutorials.
You'll find them here:
http://www.mousetrax.com/techpage.html#autoforms

You should probably start with the PLEASE FILL OUT THIS FORM series
(but skip # 5, that's advanced database connectivity).

But know that what you want to do will be a bit of a learning curve if
you don't know VBA.

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html 
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html 

>I am trying to understand if it is possible to create a questionnaire where
>questions are hidden until a certain answer is given.
[quoted text clipped - 4 lines]
>I presume some sort of macro would be needed for this? Any help much
>appreciated.
Greg Maxey - 24 Oct 2006 20:03 GMT
Dian,

We are thinking along common lines wrt the AT.  I posted a rather
lenghty potential solution to this same user (I think) and then another
much longer post discussion stumbling blocks that I did in fact stumble
over ;-).

Regardless of my bumbling, you are right.  It is possible ;-)

> Yes, it's POSSIBLE. But it'll depend on how to design up your template
> as to how it would work. So providing a lot of details would be
[quoted text clipped - 41 lines]
> >I presume some sort of macro would be needed for this? Any help much
> >appreciated.
Dian D. Chapman, MVP - 24 Oct 2006 22:32 GMT
<whoosh it shoots over her head> Huh???? ;-)

Dian ~

> lines wrt the AT.
Greg Maxey - 24 Oct 2006 22:37 GMT
with respect to the AutoText approach.

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> <whoosh it shoots over her head> Huh???? ;-)
>
> Dian ~
>
>> lines wrt the AT.
Dian D. Chapman, MVP - 24 Oct 2006 23:01 GMT
Ah.

Dian ~

>with respect to the AutoText approach.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.