How to rename hyperlink path name

[dizy8]

Hi guys,

I have this button so that I can open a PDF file. Is there anyway where I can rename the hyperlink path? I want to change it to "soft copy". The coding of my button is below.

Private Sub Command461_Click()


Dim Fd As FileDialog
Set Fd = Application.FileDialog(msoFileDialogFilePicker)
With Fd
.AllowMultiSelect = False
.Title = "Select Only One File"
.Filters.Clear
.Filters.Add "Pdf file", "*.pdf*"

If .Show Then
For Each VtrSelectItem In .SelectedItems
Me.Pdfcopy = VtrSelectItem
Next VtrSelectItem
Else
'error when we cancel dialog box
MsgBox "No file Selected", vbInformation, "Cancelled"
Me.Pdfcopy = ""

End If
Set Fd = Nothing
End With
End Sub

[dizy8]

I want to change the filepath below in the Pdfcopy column to "Soft copy"

[moke123]

I want to change the filepath below in the Pdfcopy column to "Soft copy"

there is nothing below.

[Gicu]

If your field is a true hyperlink then you can modify the display text property to say "Soft Copy"; if you actually store the path as short text it won't work. But you can fake it on the form by using the code you have and simply adding a textbox with the control source: =Nz([Pdfcopy],"Soft Copy")
Now hide or minimize the original control and you should be good to go....

Some links for you if the field is set as hyperlink:
https://www.access-programmers.co.uk...erlink.288466/
https://www.access-programmers.co.uk...report.215530/

Cheers,

[moke123]

oddly enough if you look at the list of your posts it has a link but broken

[Gicu]

@moke123 I just tried both of them on my phone and they work for me ��.
EDIT: sorry, I get it now, you were looking in the OP's profile for the list of posts....please ignore

[moke123]

Yea it looks like he posted a picture and referred to it being below but I don't think it worked.

[Welshgasman]

Yea it looks like he posted a picture and referred to it being below but I don't think it worked.

Yes, this site lets you paste a picture (just as you can at AWF, but that stays pasted). Here it does not. Needs to be uploaded by Attachments button.

[dizy8]

Hi guys,

I have saved the attachment on this link.

Access.pdf

Thank you

[dizy8]

Hi Vlad..I tried your suggestion but this is the result..Kindly see the link below. The "Soft Copy" is not clickable anymore and also it will change name only if under "Pdfcopy" is blank. Please see below link.

Sample.pdf

Thank you.

[June7]

Are you saving path into a Hyperlink field or a normal text field?

Access Hyperlink is composed of 3 parts separated by # character. http://allenbrowne.com/casu-09.html

Can construct a clickable Hyperlink string from text field and if you want "Soft Copy" to display: ="Soft Copy#" & [fieldname] & "#"
Set textbox IsHyperlink property to Yes.

Also review: http://allenbrowne.com/func-GoHyperlink.html

[dizy8]

Hi June!!!

It's working perfectly!!! Thank you so much for your help and sharing your expertise!

Daisy