Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Forms (Word 2000)

    I have a form with a drop down box. I would like to automate the form. If I select a particular item from the drop-down list, I want a title in my form to change. Can Word do that?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Word 2000)

    Welcome to Woody's Lounge!

    Is this a userform in the VB Editor, or a form in a document? If the latter, did you create the drop down box from the Forms toolbar or from the Control Toolbox?

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Word 2000)

    This is a form in a document and I used the Forms toolbar to create my drop-down box.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Word 2000)

    Thanks. Should the title change to the text selected in the dropdown list, or to something else? If the latter, how?

  5. #5
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Word 2000)

    Ok, let me explain the form:

    I have a drop-down box with three options (Land Only, Marine Only, Land and Marine) at the top of the form. In the body of the form, there are different headings. One of the headings say Cargo Owner liablility. What I want to happen is this, if someone selects Land Only from the drop-down box, I want the word "Cargo" in Cargo Owner Liability to change to "Product" so it will read Product Owner Liability.

    So basically, any place that has the word "Cargo" will change to "Product" if Land Only is selected from the drop down box. Make sense?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Word 2000)

    Yep. You can do it as follows:
    - Unprotect the document.
    - Double click the dropdown box.
    - Tick the check box "Calculate on exit".
    - Note the bookmark name of the dropdown, it'll be something like Dropdown1.
    - Click OK.
    - Go to the heading Cargo Owner Liability.
    - Delete the word Cargo (don't worry, it'll be back).
    - Press Ctrl+F9 to insert field brackets { } (don't type the brackets yourself)
    - Type IF followed by a space.
    - Press F9 again to insert another pair of field brackets.
    - Type the name of the dropdown bookmark between the inner set of brackets.
    - Click between the closing brackets.
    - Type = "Land Only" "Product" "Cargo"
    - The field codes should now look like this:

    { IF { Dropdown1 } = "Land Only" "Product" "Cargo" }

    - Press F9 to update and hide the field codes.
    - Protect your document for forms.

    When you select an option in the dropdown list and Tab out of the dropdown, you should see the heading change automatically.

  7. #7
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Word 2000)

    Thank you. I followed your instructions, but it didn't work for me. What could I have done wrong?

  8. #8
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Word 2000)

    Ok, here is my problem now. Right after my drop-down box, I have inserted a continuous section break to allow the users to add more bullets if necessary. I need to protect the section with the field code and I having problems doing that without messing up a user adding bullets. Does that make sense?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Word 2000)

    Hard to say without seeing what you have done.

    I have attached a small working demo document. If that doesn't help, could you post a copy of your document? Strip out text not needed to understand the problem, and sensitive or proprietary material.
    Attached Files Attached Files

  10. #10
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Word 2000)

    Here is an example of the document. The users need to be able to add extra bullets if need be, that's why I can protect the entire document.
    Attached Files Attached Files

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forms (Word 2000)

    The problem was that the entries in the combo box are not "Land Only" etc., but "(Land Only)" etc. You must use EXACTLY the same text in the IF field as that used in the combo box.

    See attached version.
    Attached Files Attached Files

  12. #12
    New Lounger
    Join Date
    Nov 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Forms (Word 2000)

    Thank you for all your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •