add more than one URLs in a hyperlink field

  • Thread starter Thread starter jack
  • Start date Start date
J

jack

I have a field called NewURLs whose datatype is hyperlink. can someone
tell me how to add more than one links in the field. for example, the
NewURLs are link1 and link2. but after I add the hyperlink to the word
link1, it becomes the hyperlink of the field and I can not highlight
the word link2 and add another hyperlink.
I don't want to set the field to be text and directly paste the URLs in
the field because those URLs are too long.
thanks for any help!
 
jack said:
I have a field called NewURLs whose datatype is hyperlink. can someone
tell me how to add more than one links in the field. for example, the
NewURLs are link1 and link2. but after I add the hyperlink to the word
link1, it becomes the hyperlink of the field and I can not highlight
the word link2 and add another hyperlink.
I don't want to set the field to be text and directly paste the URLs
in
the field because those URLs are too long.
thanks for any help!
Click to expand...

A hyperlink field can only hold one hyperlink; that is, one URL. What
is your intention in wanting to add two URLs to one hyperlink field?
Did you want both URLs to open in separate browser windows when the
field is clicked on, or what?
 
Dirk, thank you for the help!
here is an example, I have two fields, ID and favoriteURLs. so there
can be more than one URLs for each ID. What I need is to store more
than one URLs in the FavoriteURLs field for each ID. for example, the
FavoriteURLs for ID 1 are google and yahoo. So when I click the word
google, IE should open the www.google.com site. and when I click the
word yahoo, IE should open the www.yahoo.com site.

thanks again!
 
jack said:
Dirk, thank you for the help!
here is an example, I have two fields, ID and favoriteURLs. so there
can be more than one URLs for each ID.
Click to expand...

Then you need a separate "related" table to store the URLs in.
 
jack said:
Dirk, thank you for the help!
here is an example, I have two fields, ID and favoriteURLs. so there
can be more than one URLs for each ID. What I need is to store more
than one URLs in the FavoriteURLs field for each ID. for example, the
FavoriteURLs for ID 1 are google and yahoo. So when I click the word
google, IE should open the www.google.com site. and when I click the
word yahoo, IE should open the www.yahoo.com site.
Click to expand...

Rick Brandt is right. Multiple data items related to the same
"owner" -- such as your multiple URLs related to the same ID -- should
be stored in a separate table that is related many-to-one with the
owner. You could use a subform to present these and edit them.
 
Back
Top