Is there a way to use VBA or Access SQL to change a field type in a table to Hyperlink?
I can change a field type to text using the following SQL: ALTER TABLE TableName ALTER COLUMN ColumnName TEXT(255)... works like a charm.
However, the following SQL fails: ALTER TABLE TableName ALTER COLUMN ColumnName HYPERLINK
Taking a look at Type Conversion functions I don't see, can't find anything I can use with VBA. Is there's an API function available?
Any help would be greatly appreciated.
I can change a field type to text using the following SQL: ALTER TABLE TableName ALTER COLUMN ColumnName TEXT(255)... works like a charm.
However, the following SQL fails: ALTER TABLE TableName ALTER COLUMN ColumnName HYPERLINK
Taking a look at Type Conversion functions I don't see, can't find anything I can use with VBA. Is there's an API function available?
Any help would be greatly appreciated.