Joe said:
Hi
Please , I need your help.
How to create a HYPERLINK data field using SQL syntax?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
A hyperlink column is, in reality, only a TEXT data type column, which
means the SQL command to create it is:
column_name TEXT,
To have the hyperlink show the Hyperlink format you have to create the
column (DAO.Field) and assign the dbHyperlinkField attribute to the
field's Attribute property by ORing it to the existing attribute:
Attribute = Attribute OR dbHyperlinkField
You have to do this before you append the field to the TableDef.
See the Access VBA Help articles on DAO.Fields, CreateField, and Append.
HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSo74pIechKqOuFEgEQKiVwCg9SJsLWWmZ7fsy/vSE9+15WjwTrIAoKPu
znQWoAvLVQYW/HChs9cxzmSy
=1gcP
-----END PGP SIGNATURE-----
