hyperlinks

[sdel_nevo]

Hi Guys

i am trying to remove the #http:// that appears before a hyperlink in a text box is this possible to do?

i have a calculated feild in a table called customer website that is formatted to text

it contains the value website that is a hyperlink

when i view this text box in a form it adds #http:// to the beginning and # at the end.

can i remove this so it just shows the website www.mysite.com

hope this makes sense



Steve

[June7]

Try:

Replace(Replace([fieldname],"#",""),"http://","")

or


Mid(Replace([fieldname],"#",""),8)

[sdel_nevo]

Hi June

you are a star, many thanks

Steve