Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenate a field into a hyperlink (Word 200)

    Could anyone help please?
    I have a form field, which Users MAY add a number into. IF they do, i would like to add a hyperlink to a command button, relating to this number.
    For example, IF a User adds in a number, let's say 1234, then the hyperlink will need to be http://abc//default.asp?Category=1234.

    Would you be able to suggest a solution please?

    Thanks GriZlore

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

    Re: Concatenate a field into a hyperlink (Word 200)

    You mention 'form field', but you also mention a command button. Is this in the body of a document, or on a userform created in the Visual Basic Editor?

  3. #3
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate a field into a hyperlink (Word 200)

    it's in the main body of the document.
    A User will type a number into a form field. Using this number, I would like to create a hyperlink, based on this number
    Command Button, may have been misleading, sorry. I just want a hyperlink, in which the end of it is the number the User has entered.

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

    Re: Concatenate a field into a hyperlink (Word 200)

    Double click the form field while the document is unprotected.
    Tick the check box "Calculate on Exit".
    Note the bookmark name of the text box (you can modify it if you wish).
    Click where you want the hyperlink. This should be in an unprotected section of the document, for hyperlinks in a protected section don't work.
    Press Ctrl+F9 to insert field braces { } (don't type the braces yourself)
    Type the following between the braces:

    HYPERLINK "http://abc/default.asp?Category=

    Press Ctrl+F9 to insert another pair of field braces.
    Type the bookmark name between this pair of braces.
    Type a double quote immediately after the inner closing brace.
    You should see something like this:

    { HYPERLINK "http://abc/default.asp?Category={ Text1 }" }

    Press F9 to hide the field codes and update the field.
    Protect the document.

    When the user enters a number and presses Tab, the hyperlink will be updated.

  5. #5
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate a field into a hyperlink (Word 200)

    many thanks

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Concatenate a field into a hyperlink (Word 200)

    I'm trying to emulate this with a slighlty diffrent objective, but without success. MY objective is to create a protected form with a partial hyperlink which must be completed by the user to indicate final files (no hyperlink and the ability to navigate to and insert one would be fine).

    Starting with a Text Form Field, using Ctrl-F9 twice I'm embedding {hyperlink "file://myserverfinancecustomerscontractedfees{enter folder and filename here}"}

    Depending how I do it, when I reprotect the document either the field disappears, or it reverts to a straight text field or the link is active but not editable.

    If all else fails can I invoke a macro form the text field to open the Insert Hyprerlink dialog, and if so will the hyperlink be active?
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Concatenate a field into a hyperlink (Word 200)

    The "prompt" should be the bookmark name of a form field - this name cannot contain spaces, like all bookmark names.
    The hyperlink should be in an unprotected section of the document; hyperlinks in a protected section cannot be clicked.

    See attached document. Enter a valid post number in the form text box, press Tab to update, then Ctrl+click the hyperlink.
    Attached Files Attached Files

Posting Permissions

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