I have created a very simple code to fill automaticly an hyperlink field when a text box is updated on a form:
Me.txtHyperlink = "F:\Data\CPP\CPP PDF\" & [TxtPipeSize] & "\" & [DrawingFile] & "\" & [PartNumber] & ".sht" & [TxtSheetNo] & ".Rev" & [TxtRevNo] & ".pdf"
TxtHyperlink is bound to the hyperlink field, when the code is executed the Hyperlink field is filled with the right address. but I think the code just fill the text to display "parameter" of the hyperlink field and not the actual adddress.
what should I do to get the result of the function to be saved as the Hyperlink address?