hyperlink issues

[bigmac]

hi all, I have a text box on my form which I use to attach hyperlinks to pdf's, this works great but after inserting a hyperlink nothing is displayed in the text box to show it has been linked unlike using attachment, the only way I know if that a hyperlink is placed is to right click and go to hyperlink and then open,
is there a way to show the link on the text box and just double click on it to open the pdf.
any ideas please,
p.s I am trying this as the size of the database will far exceed the 2gb that access allows if I just use attachments , even if I split the database (over 10000 pdfs )

 

[pr2-eugin]

You have gone the right way in using Hyperlinks over attachments. But your description does not make very clear picture of the problem you are facing, I use a similar method.

1. Have a field in my table as Hyperlink.
2. On the Form I have a Listbox that lists all attachments for the customer.
3. On Double click I have FollowHyperlink method to open the Document.

Where are you having trouble?

 

[bigmac]

pr2-eugin thanks for your interest, i have solved the problem. the issue was that when i changed the pdf field in the table to hyperlink and then inserted a hyperlink into the text box all worked ok but nothing would show in the textbox to indicate that it a hyperlink in it. i found out that if i deleted the textbox and re inserted it into the form then it would show the hyperlink. i hope this helps .