Using hyperlinks in ms access 2007

[Aaron007]

WE frequently use Microsoft Access 2007 at office. I have created some hyperlinks in my Access 2007 that should take me to a web page related to the specific record or the link provided under the hyperlink. But the problem is while clicking on the hyperlink, nothing happens. The hyperlink won't work. Please help.

[Macarenas]

The value returned depends on the setting of the part argument. The part argument is optional. If it's not used, the function returns the value Microsoft Access displays for the hyperlink. The returned values can be one of the four parts of the Hyperlink field, the full address, address#subaddress, or the value Microsoft Access displays for the hyperlink.The place using Impression as Hyperlink caused the text in TextBox or ComboBox for colored blue and underlined. Moreover, when hanging on the control, the cursor is a pointer in a Hand of the Hyperlink.

[JonathanD]

When you type a link into the datasheet's Hyperlink, it consist the text, the destination you go to when you click the cell and text you see when you hover over the link with your mouse. So while typing the link all these are set to the same value what you just typed in. So when you type http://www.techarena.in, the text you see, the URL link, and the tooltip are all set to hold the same content,which is the URL http://www.techarena.in. When a value is provided in the displaytext part of a Hyperlink field, the value displayed by Microsoft Access will be the same as the displaytext setting. When there's no value in the displaytext part of a Hyperlink field, the value displayed will be the address or subaddress part of the Hyperlink field, depending on which value is first present in the field.

[Eric B]

You can add or edit the displaytext part of a hyperlink field by right-clicking a hyperlink in a table, form, or report, pointing to Hyperlink on the shortcut menu, and then typing the display text in the Text to display box.There’s an additional option for Display As Hyperlink “Screen Only”. This is a great option to use when building the kinds of interactive reports which are now possible with Access 2007.