URL & other linked documents in form

[stealth3]

Hello

I have a field in my database called Notes where I store information such as URLs and filepathway to documents on our local server. Can I make them active (hyperlinked)?

thank you

Aysen

 

[Lightning]

In Table Design view, set the field type to "Hyperlink".
In Form Design view, select the bound control and set the Is Hyperlink property to Yes.

HTH
Lightning

 

[stealth3]

Thanks Lightning

However not all the contents in that field would be hyperlinked. I only include a URL or local server address if the document is available electronically. I thought that I could select the URL and hyperlink it.

 

[Lightning]

No, you can only format the field as a hyperlink, not selectively format the data in the field as a hyperlink.

The easiest solution (and to comply with standard Normalisation requirements) would be to create a separate field in the table just to hold this data, rather than using one field for two different types of data.

HTH
Lightning

 

[stealth3]

Thank you. I will leave it as it is.

cheers

Stealth