I have created a form in VB to enter data into an Access table. One of the fields in the db table is of data type hyperlink, and links to a document that is being stored in .pdf format.
The code for the box in VB is txtBitRecordFile.text = txtBitRecordFile &"#C:\My Documents\PDFDocs\"&txtBitRecordFile&"#"
where txtBitRecordFile is the file number as entered into the form text box.
When I look at the table data, the field stores the file number as a hyperlink (blue and underlined) and when I mouse over the hyperlink value, I get the correct path displayed C:\My Documents\PDFDocs\S47146.
I created a report in Access, but the control does not work like a hyperlink. The only thing displayed is the value in the field, which in this case is S47146.
What I want is the record information with a control that has a hyperlink in it to take the user to that document if they want to see that whole document.
Thanks for your help in advance.
BusMgr
The code for the box in VB is txtBitRecordFile.text = txtBitRecordFile &"#C:\My Documents\PDFDocs\"&txtBitRecordFile&"#"
where txtBitRecordFile is the file number as entered into the form text box.
When I look at the table data, the field stores the file number as a hyperlink (blue and underlined) and when I mouse over the hyperlink value, I get the correct path displayed C:\My Documents\PDFDocs\S47146.
I created a report in Access, but the control does not work like a hyperlink. The only thing displayed is the value in the field, which in this case is S47146.
What I want is the record information with a control that has a hyperlink in it to take the user to that document if they want to see that whole document.
Thanks for your help in advance.
BusMgr
