Is it possible to create conditional formatting in a drop down form field?
I.E. if you make a selection from the drop down menu another choice that
relates to that selection will show up.

Hi ?B?cm9lc2VyYg==?=,

Is it possible to create conditional formatting in a drop down form field?
I.E. if you make a selection from the drop down menu another choice that
relates to that selection will show up.

Choice and formatting are two different things. Could you please formulate
your question in more detail, and include information about the version of
Word?

In any case, what you want would require macro programming.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Cindy:

Thanks for your reply. I am working in office word 2003. I am creating a
selection sheet for our clients to choose their menu for a river trip. When
someone, for example, chooses a pasta from the drop down menu, they also need
to choose a sauce for it. I am trying to prompt them to make the choices
automatically.

I hope that explains it.

Beth

"Cindy M -WordMVP-" wrote:

Hi ?B?cm9lc2VyYg==?=,

Is it possible to create conditional formatting in a drop down form field?
I.E. if you make a selection from the drop down menu another choice that
relates to that selection will show up.

Choice and formatting are two different things. Could you please formulate
your question in more detail, and include information about the version of
Word?

In any case, what you want would require macro programming.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Hi Beth,

I am working in office word 2003. I am creating a
selection sheet for our clients to choose their menu for a river trip. When
someone, for example, chooses a pasta from the drop down menu, they also need
to choose a sauce for it. I am trying to prompt them to make the choices
automatically.

I hope that explains it.

Yes, you definitely need to use a VBA (macro) solution. It would have to be
assigned to the "On exit" property in the form fields "Options" dialog box. The
macro would pick up the selection, unprotect the form, fill the other dropdown
box, then reprotect the document.

Alternately, you could use an "On Enter" macro with two TEXT boxes. This would
display a UserForm where the user could make both choices at the same time (the
advantage would be that the form wouldn't need to be unprotected/reprotected).

1. you have to determine whether your document is allowed to contain macros.
Macros will trigger Word's macro security, meaning your document probably wouldn't
be available to all users.

2. You have to decide how you want to manage the data. It can be hard-coded into
the macro, which means whenever anything would change you'd have to edit the macro
code. Or the data could be managed in an outside file. This would be more flexible
to maintain, but more difficult to code.

Is it possible to create conditional formatting in a drop down form field?
I.E. if you make a selection from the drop down menu another choice that
relates to that selection will show up.



Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-)