Adding Hyperlink into Textbox with Text

[tylerg11]

Is it possible to combine a hyperlink with text data in the same textbox. For example, If I wanted to have a field that contains hotel information, and I type the name of the hotel and add a link for directions in the same textbox. Can one textbox contain both text and hyperlink data? Or would this have to be two different fields?

[June7]

As far as I know, two fields.

[tylerg11]

Kinda figured so. So, with a compiled database, is it possible for the user to just copy and paste a URL into the hyperlink field, and then Access will activate it?

[June7]

Yes, can copy/paste into field, then click to run.

[tylerg11]

But the field data type has to be hyperlink too, right? I'm actually using SQL server, so what would be the data type for the field that I want to automatically convert isnerted text into an active hyperlink?

[June7]

Sorry, don't know about SQL data storage.

Review this thread http://forums.aspfree.com/sql-develo...ld-161973.html

And this tutorial http://allenbrowne.com/func-GoHyperlink.html