Web Link for stored URL

[Rob001]

I want a URL stored in one field in my table to be recalled and formatted as a link to a web site on my form. How can i do this? Do i need to format it in the table or do i do it in the form - or do i need a query to do it?

 

[yessir]

explain

could you explain more

 

[Rob001]

i want to store web site links in a field in my table, e.g./ http://www.amazon.co.uk. Then i want some sort of access point (such as a button) on my form to link to this web site.

 

[yessir]

ok

in your table save the info as a hyperlink and then have record access, or some way you want to retrieve it

then if you right click and say open hyperlink it opens

 

[yessir]

also

also you can just click on the name if you look through it first

 

[yessir]

i just

i just don't know y it puts in the #www....#

if you just return the table as a child it shoul dwork out fine

 

[Rob001]

thanks for that, i recon i can sort it now

 

[Rob001]

now theres another problem.

I have all other fields on the form locked and unabled so that they dont appear as text boxes and data cannot be changed.

If i do this to the url text box though, it cannot be used as a link. How can i let a user use the link, but make it not appear as a text box - i.e. the text isnt highlighted when the form opens.

 

[yessir]

txtbox

change the properties of the txtbox to be uneditable, and the outline to not be shadowed...

thus leave it as a text box but change it to look as though just a hyperlink on the form

 

[Rob001]

how do i make it "uneditable"?

If i lock it and unable it, then the hyperlink wont work - its blocked out from use.

 

[yessir]

just set

just set the property of the textbox appear as if it were just part of the form

set special effect to flat
set border style to transparent
and leave unlocked

if all the other things are locked,

go to the form properties and make it uneditable there