Dafault hyperlink text

[ortizgabe]

Hello, I finally figured out how to have users drag and drop a document into a text box within a form and have it create a hyperlink. What I need to know now, is if there is a way that when a file is dropped into the text box, it only shows the icon associated with that file, or at the very least, edit the hyperlink to only show a certain text. The files I need to see are all in a networked drive, so the hyperlink addresses can be quite long, and ultimately I'd just like the hyperlink to say "letter". Showing the icon would be a plus.

Thanks for any help!

[June7]

How do you do 'drag and drop'? This is saved into a text type field? A true hyperlink would be saved into a hyperlink type field and be composed of 3 parts, any of which can be edited by code or through the hyperlink dialog. Review: http://www.allenbrowne.com/casu-09.html

[ortizgabe]

Thanks for the reply! So what I did was create a new column in my table and designated it as a Hyperlink in data type. Then I created a text field in my form and made the control source the column I just created. This allowed me to dag and drop my file from explorer into the text field and it creates a hyperlink to the location for me. I took a look at your reference, but to me it seems like that is used to changed the hyperlinks one at a time, I'd like it to happen as soon as the file is dropped into the text field. Unless what you are saying is that I can put those variables somewhere on my database, I just don't know where that would be.

[June7]

Would have to use VBA code to modify the hyperlink string that is saved. Trick is figuring out what event to put the code into. Probably the textbox AfterUpdate. The following worked for me:

Dim aryH As Variant
aryH = Split(Me.textboxname, "#")
Me.textboxname = InputBox("enter display text") & "#" & aryH(1) & "#" & aryH(2)