Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink display (Access 2003)

    I have a hyperlink in a form. I'm showing the form as datasheet view. I don't want to display the whole path on the form. Can I set an alias?

    TIA

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

    Re: Hyperlink display (Access 2003)

    Right-click the hyperlink. Select Hyperlink from the popup menu and click in the Display Text box. You can enter the alias here. This can be done in the table itself or in the form.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink display (Access 2003)

    If I have 300 records how do I change all of them to the same text "Recon" or to part of the link at once.

    TIA

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

    Re: Hyperlink display (Access 2003)

    If you want to set them all to the same text:

    - Create a backup first, for if the results aren't what you want.
    - Create a query based on the table.
    - Add the hyperlink field to the query grid.
    - Select Query | Update Query.
    - Enter the following expression in the 'Update to' line, substituting the correct field name:
    <code>
    "Recon#" & [FieldName]
    </code>
    - Select Query | Run or click the Run button on the toolbar.

    If you want "part of the link", please explain what you have in mind.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink display (Access 2003)

    The manual operation that only applies to one record at a time - how do I do this programmatically so i can run through all the rows in the table

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

    Re: Hyperlink display (Access 2003)

    A hyperlink is stored in the form
    <code>
    TextToDisplay#Address#SubAddress
    </code>
    where TextToDisplay and SubAddress may be empty. If TextToDisplay is empty, the Address itself is used as display text.

    So if you wish, you can loop through the records and set the hyperlink field to a string of the above form.

  7. #7
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink display (Access 2003)

    Thanks for the advise. To confirm what you are saying is if I have a table with a hyperlink field I won't be able to set the display property on a form to any value ("RECON") and still maintain the functionality that if the user clicks the Recon then it will take the user to a file as listed in the hyperlink. Do I need to change the table?

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

    Re: Hyperlink display (Access 2003)

    That's not what I said at all. You can make the hyperlink field display the same text in all records and yet have it open a different file in each record. The easiest way to do that is an update query as described higher up in this thread.

  9. #9
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink display (Access 2003)

    Sorry Hans. I tried your update and it works. I thought that the update will work similar to any other field update that if you ask for "Name" & {field] say field is 123 it will display Name123 but on the hyperlink it only shows the "Name"

    Thanks for all your help. I went with the update query and it works fine.

    Regards

    Mario

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

    Re: Hyperlink display (Access 2003)

    The field only shows the name because there is a # behind it. As mentioned in my previous reply, # delimits the three parts of a hyperlink.

Posting Permissions

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