Access 2003 Using a field as a URL 1

[RBP]

Simple this one....

I have a small Database.

One table, 10 or so fields, one of which is a list of URL's

http://www.google.com,

http://www.yahoo.com

etc, this table field is defined as Hyperlink.

One query based on this Table for sort purposes.
Then one Form based on the query.

Everything displayed on the Form hunky dory, when the Form is open, click the displayed hyperlink, and I.E. kicks off, Great!

What I want to do is to let the user edit the Hyperlink field, from the Form.

eg a change

http://www.google.com

to

http://www.google.com/about.htm.

At the moment the URL field is defined as hyperlink, field on the form is Enabled and Locked. this with a transparent background, and textbox shows the URL as a 'Proper' link.

Great so far, What I want to do is have a click button ( and associated code) that opens the field for proper text editing, to then update the hyperlink.

Does this make sense, and can anyone suggest anything?
I can give more detail.

Thanks in advance.

 

[PHV]

Take a look at the HyperlinkPart method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RBP]

Thanks PH Will check and experiment with that.

 

[RBP]

Sorry PH Can't make head or tail of this, I'd like to display the URL as a text string (after say clicking an edit button)then be able to alter the text (misspelled URL etc) then save the change.

Tried a few variations of the Hyperlinkpart method, and I can't get it to do anything, do you know where I can find a simple mickey mouse eg of the method?
Thanks - sorry for being a pain!