dual website address on report

A

Allen Browne

The Hyperlink field contains three (or four) pieces of information.
Use HyperlinkPart() to parse the address part.

Set the Control Source of the text box on your report to:
=HyperlinkPart([MyField], 2)
You will also need to change the Name of the text box if it is the same as
the field name.

For more information on how the hyperlink field is made up, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting the same character automatically in each cell 3
How do I manipulate a string to collect the address from it? 1
Web Link in Forms 2
Further Question about Transpose 3
Import Data 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Newbie has questions 1
Access 2007 Report shows multiple rows, query shows single row 0

Top