Remove "http://" from hyperlinked database result

[Phizzle]

I have a database result that I have set a field to contain HTML (my
database field is an href w/ a mailto problem is when I get the
results I get http://Email Us - how can I get rid of the http://?

Thanks!

 

[Phizzle]

Forgot to mention - Frontpage 2000 w/ Access 97 database connection

 

[Kathleen Anderson [MVP - FrontPage]]

In Normal view, right-click on the field, select Hyperlink, choose
Parameters, delete http:// from the Path box and type mailto: in its place.
Choose Insert Field Value, and select the fieldname containing the e-mail
address from the dropdown list.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Phizzle]

That was painfully easy! Thanks!!

 

[Kathleen Anderson [MVP - FrontPage]]

You're welcome! If you ever upgrade to FP2002 or FP2003, you'll find
instructions for those versions as well on this page:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#email

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Sara Campney]

How do you keep from having to do this every time. Is there a default that
you can set or clear so it doesn't show up in the first place?

 

[Kathleen Anderson [MVP - FrontPage]]

No, there's no default setting. But the good news is that you only have to
do it once for each Database Results Region, not once for each record in
your database.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Stefan B Rusynko]

If you don't make the DB field a hyperlink field in the first place
- it won't ever show up

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| No, there's no default setting. But the good news is that you only have to
| do it once for each Database Results Region, not once for each record in
| your database.
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
|
|
| | > How do you keep from having to do this every time. Is there a default
| > that
| > you can set or clear so it doesn't show up in the first place?
| >
| > "Kathleen Anderson [MVP - FrontPage]" wrote:
| >
| >> You're welcome! If you ever upgrade to FP2002 or FP2003, you'll find
| >> instructions for those versions as well on this page:
| >> http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#email
| >>
| >> --
| >>
| >> ~ Kathleen Anderson
| >> Microsoft MVP - FrontPage
| >> Spider Web Woman Designs
| >> web: http://www.spiderwebwoman.com/resources/
| >>
| >>
| >> | >> > That was painfully easy! Thanks!!
| >> >
| >>
| >>
| >>
|
|

 

[Murray]

I guess I have never used the hyperlink field type for that reason....

Just make it a hyperlink when you put it on the page instead.