hyperlink table formats

[wozinuk at graffiti.net]

Hi guys
I am look for a way to change en masse the format that is
assigned when you store a hyperlink. For individual
records you can right-click and edit a hyperlink (in this
case I want to change to an email address) and select
email. the http:// is changed to mailto:

This is the exact format that I want and it works a treat
but I have thousands of records. Can I change the format
of the table to default to the mailto: prefix. if not can
it be done programttically or with an update query or
something? . help!

 

[Lynn Trapp]

1. Temporarily change the datatype of your field to TEXT
2. Run the following update statement (changing the table name and field
name appropriately):

UPDATE HyperLinks SET HyperLinks.EmailAddress = "#Mailto:" &
Mid([EmailAddress],9);

3. Change the datatype of y our field back to Hyperlink.