HYPERLINKS - ACCESS 2000

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

I have 2 hyperlinks in my form, one for a web address and
the other for an email address. Is there a way that I can
change the default for the email address to "mailto"
without having to edit the hyperlink and change it
to "mailto" manually every time I enter an address. Am an
Access 2000 novice with a database of 2201 records to
change. Any help would be very much appreciated
 
There is not a simple way to preset the prefix for a hyperlink field to
"mailto". My preferred approach is to store the email address in a Text
field, and prefix the "mailto" (or use SendObject) in the Click or DblClick
event of the text box.

You can mess with the AfterUpdate event of the text box you use for the
Hyperlink field, and use HyperlinkPart to parse the entry and replace
"http://" with "mailto:". I've not been too happy with that approach,
because it makes assumptions about what is in the field already, and types
that may come to exist in the future.

If you want to alter your existing data, you could use an Update query, with
HyperlinkPart(), Replace(), and set the criteria to those Like "http://*"
 
Back
Top