Access 365 64-bit Windows 11
I have a textbox where I drop a file which pastes the link to the file. I then copy the path to the current record's file folder. In Access, I separate the newly copied path & filename, creating a hyperlink to the file in client's record.
The problem is that when I drag a file to the TB, it pastes the link twice, i.e.,
"..\Desktop\doc_rptObjects.txt#..\Desktop\doc_rptObjects.txt#".
What makes it so hard to figure out is that it happens at the drop. I put the first line of "After Update" as "Debug.Print the textbox text" and that's what is there.
I have a workaround where I half the length of the text to get what I'm looking for.
Dim ln As Long: ln = Len(Me.Documents.Text) Dim myPath As String: myPath = Left(st, ln / 2)
This gets me the proper path, but it seems like I'm addressing the symptom and not the problem. Any ideas?
Thank you,
