By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 1,905 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

Stamping in a Hyperlink populates the Display Text but not the Address

P: n/a
In the part of my code that writes the variables to the table:
..
..
..
mFullURL = "http://www.microsoft.com"
..
..
..

With rsTblURLs
.AddNew
.Fields("URL") = mFullURL
.Update
End With

It writes http://www.microsoft.com to the desitnation table, but if you
Edit the Link Properties (i.e., Insert Hyperlink properties) it shows
up only as the text to display. The Address itself if blank. Any
ideas as to why the address isn't being populated?

Thanks in advance,

RBollinger

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
OOPS -- This is Access 2003

Nov 13 '05 #2

P: n/a
A hyperlink consists of at least 3 parts, with the # between them.

More info and examples in:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"robboll" <ro*****@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
OOPS -- This is Access 2003

Nov 13 '05 #3

P: n/a
Thanks for the information. And that leads to a related question.

If a hyperlink consists of three parts, how is the "address" part
populated when writing to a hyperlink field using Access 2003?
Specifically...

If mlink = "http://www.myurl.com"
and you want to write mlink to a hyperlink field, so that the display
text AND the address are populated what is the best method?

Thanks for any tips.

RBollinger

Nov 13 '05 #4

P: n/a
Try:
mlink = "http://www.myurl.com#http://www.myurl.com#"

Use HyperlinkPart() to parse the hyperlink.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"robboll" <ro*****@hotmail.com> wrote in message
news:11*********************@g43g2000cwa.googlegro ups.com...
Thanks for the information. And that leads to a related question.

If a hyperlink consists of three parts, how is the "address" part
populated when writing to a hyperlink field using Access 2003?
Specifically...

If mlink = "http://www.myurl.com"
and you want to write mlink to a hyperlink field, so that the display
text AND the address are populated what is the best method?

Thanks for any tips.

RBollinger

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.