J
John Schneider
I have an Access 2002 table with fields containing web links (in text
format). I need the field in this DataType so the it can be sorted and used
to exclude duplicate records with the same link, therefore I don't want the
DataType to be hyperlink. Also, it's considerably less difficult to update
or correct the link as textual data than when it's formatted as a hyperlink.
What I do want is to query the table and create a hyperlink DataType field
of the textual data so the link can be tested and/or accessed. I did this
before easily, after researching for hours, but lost my code and can't
remember how I did it. Any help??
John Schneider
02:40:32 AM Tue 10/11/05
format). I need the field in this DataType so the it can be sorted and used
to exclude duplicate records with the same link, therefore I don't want the
DataType to be hyperlink. Also, it's considerably less difficult to update
or correct the link as textual data than when it's formatted as a hyperlink.
What I do want is to query the table and create a hyperlink DataType field
of the textual data so the link can be tested and/or accessed. I did this
before easily, after researching for hours, but lost my code and can't
remember how I did it. Any help??
John Schneider
02:40:32 AM Tue 10/11/05