Solved: Hyperlink

[kbsudhir]

How many charcters can be there in the field with hyperlink as the datatype.
I am loading a path of a file in that column & want to open the file when I click the hyperlink.

Regards
Sudhir

[Movian]

After a quick Google session i found this (http://www.google.com/url?sa=t&source=web&ct=res&cd=3&url=http%3A%2F%2Ffog.ccsf.edu%2F%7Ewkaufmyn%2FCS150A%2FCourseHandouts%2FDat aTypes_Access.doc&ei=S2sMSuD8E4yc8gSJ1rjQDw&usg=AFQjCNHx_OS9j95BkosRqh2xYFefF4t6zg&sig2=EcKfaL3bpvc4mnfsXx33YA)

Which gave me this information

Text or combinations of text and numbers stored as text and used as a hyperlink address (javascript:HelpPopup('actip9.hlp','defHyperlinkAddress');). A hyperlink address can have up to three parts:

text to display — the text that appears in a field or control.
address — the path to a file (UNC path (javascript:HelpPopup('actip9.hlp','defUNC');)) or page (URL (javascript:HelpPopup('actip9.hlp','defURL');)).
subaddress — a location within the file or page.
screentip — the text displayed as a tooltip.
The easiest way to insert a hyperlink address in a field or control is to click Hyperlink on the Insert menu.
Each part of the three parts of a Hyperlink (javascript:HelpPopup('actip9.hlp','defHyperlinkDataType');) data type can contain up to 2048 characters.

[CreganTur]

This thread (http://www.vbaexpress.com/forum/showthread.php?t=22921) has a lot of information about hyperlinks.