SQL Database, User interface Access, want hyperlink field - how ?

[Guest]

I have an SQL Database where I was planning on storing the data, I was
creating a user interface through Access2003 (right / wrong ?). In Access you
can have a hyperlink field in SQL you do not.

How to I have a field in a form that is a hyperlink - I get this error when
I use Edit Hyperlink and set to Email address.

"the field is too small to accept the amount of data you attempted to add"

 

[Brendan Reynolds]

You can use an nvarchar or ntext field. Take a look at 'NorthwindCS', the
ADP version of Northwind that comes with Access 2003, specifically the 'Home
Page' text box on the 'Suppliers' form. Though NorthwindCS is an ADP, I
don't think there's anything about the way this feature works that is
specific to an ADP.

 

[Guest]

Hi Brendan

Excellent that worked - however I have another small related problem.

Can i do the same with Email addresses ?

Best Regards

Alan

 

[Brendan Reynolds]

Yes, but you have to put 'mailto:' in front of the e-mail address, e.g.
mailto:[email protected]

 

[Guest]

Thanks Brendan !

Yes, but you have to put 'mailto:' in front of the e-mail address, e.g.
mailto:[email protected]