Modify a hyperlink of an Access form in VBA

[Alain17]

Hello,in an access form, there is a hypertext field called "Hyperlink"Text displayed = "CCP B 001"Link to file = "T: \ CERTIFICATION \ AQ \ DAQ \ DAQ_L \ CCP 001.xlsx"Tooltip = "CPP number 1: cooking temperature"I want to modify this field with VBA so that it becomes:Text displayed = "CCP001"Link to file = C: \ TEMP \ CCP 001.xlsx "Tooltip = "Temporary CPP number 1: cooking temperature"How to do this in VBA please?Thank you so much !Alain

[OBP]

The syntax of your new data does not match the syntax of the original data.
There are no exclamation marks around the file name.