Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Oct 2001
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop Down Form Field (Word 97)

    Anyone know how to activate the "On Entry" or "On Exit" macro function with a drop down form field in a document.

    For example, using the "Run macro on" I have selected a macro (that exists in the Module area) but it does not do what the macro contains when I select the dropdown.

    thanks,
    otk

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Drop Down Form Field (Word 97)

    Hi,

    Assuming the form is in protected mode, and the macro is in a standard module, the macro ought to be running.
    Would it be possible to attach a sample document with the offending form and code?

    Gary

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop Down Form Field (Word 97)

    otk,

    It does not run when you select the dropdown. It runs when you exit the field to go to another form field (if the doc is protected for forms).

    If you want something to run when you click on a dropdown, you may have to look at the controls from the Control Toolbox. They're a lot more flexdible- but there's more learning to do, and they do have problems like document size, load response time, and the way they appear when scrolling.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Drop Down Form Field (Word 97)

    We may have a problem with the imprecision of language here. When you say "select the dropdown" it can mean a number of things.

    Form fields work only in a document (or template) that is "protected for forms." If your document is not so protected when you select a field, it doesn't work right.

    On entry macros run when the field takes the "focus." That is, becomes the work area for the document. Normally this happens when you tab into or click on a form field.

    Nothing happens when you select a choice in a drop-down field. This is not entering or exiting the field.

    When you use the tab key to move to the next field or click anywhere outside of the field (within the document) you exit the field and an "On Exit" macro will run.

    For more on forms follow the links at <A target="_blank" HREF=http://www.addbalance.com/word/wordwebresources.htm#Forms> Word Web Resources - Forms</A> (addbalance.com/word/wordwebresources.htm).

    Hope this helps.
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

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