Link a hyperlink Field

G

Guest

I m trying to create a text field with a hyperlink to an
address but I m geting an error that the hyperlikaddress
property is Read only for this Hyperlink

the code:

With Application.FileDialog(msoFileDialogFilePicker)
.Show

For Each a In .SelectedItems
With Me.Loan_Doc
.Value = a
With .Hyperlink
.Address = a
End With
End With
Next
End With
 
A

Alex Dybenko

try to use this syntax:

With Me.Loan_Doc
..Value = a & "#" & "file://" & a
End With
 
Top