Hyperlink Coding (2000 vs. 2003)

[Glenn McWilson]

Hi all,

I created a form to hold hyperlinks to pdf and jpg files. The form has three
fields, all with the hyperlink data type. I then created a command button
that when clicked, allows the user to navigate to a file, click open and
then set the value of the field to {FieldName}#{FieldName} so that Access
will recognize the hyperlink as both display text and address.

However, Access 2000 only views the display text and ignores the address.
Any idea as to why Access 2000 only sees one part of the hyperlink? Also,
how would I go about fixing it, if I'm using Access 2003 to create an Access
2000 formatted database?

 

[Glenn McWilson]

Okay, never mind ... my brain finally kicked in and I realized I had to
include a second "#" at the end of the code. Thanks anyway.