HYPERLINKS - ACCESS 2000

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
 
A

Allen Browne

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://*"
 

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

mail merge 1
Access 2010 Disable Microsoft Access Security Notic 3
Data Access Page Hyperlinks 1
Microsoft Access 2003 5
Troubles With Email Hyperlinks 1
hyperlink field to send email 6
Sometimes Text data may be better than Hyperlinks 1
Hyperlinks on Forms for email address 3

Top