Change to hyperlink

[kitty77]

I have a table with a text field that I want to change to a hyperlink. I'm getting this error?
The table has about 36,000 records.

 

[June7]

Why do you want to use Hyperlink type? Just so the Hyperlink dialog is available? A non-hyperlink field can be used to build a hyperlink string. I avoid Hyperlink type field.

Try creating a new Hyperlink type field and run an UPDATE action to populate then delete the original field, rename the new field.

UPDATE tablename SET newfield = "#" & [oldfield] & "#"

 

[kitty77]

Thanks!

 

[HillTJ]

@kitty77 , i use some code from allenbrowne.com called 'GoHyperlink', the usage notes are easy to follow. I'd suggest you google this. Sorry, i'm writing this response from my phone & don't know how to copy/paste the link. Will do so for you when i open my PC.

 

[isladogs]

This is the link that @HillTJ was referring to...
Microsoft Access tips: Opening hyperlinks (allenbrowne.com)

 

[HillTJ]

@isladogs , Thanks for that.