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

[robboll]

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

[robboll]

OOPS -- This is Access 2003

[Allen Browne]

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

[robboll]

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

[Allen Browne]

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