Data Defnition Query

[comfrey]

I have an external table that I use to append a resident table. The external
table has hyperlinks in a Memo Field. I want to change the memo field to
hyperlink formatting. Doing so manually requires toggling back and forth
between memo and hyperlink after each append. The Data Definition Query does
not work for hyperlink. VB code might work? Don't know the code. What code
might make this work? I'm using Access 2007.

 

[Allen Browne]

JET DDL is not powerful enough to be really useful.

A Hyperlink field is actually a Memo with attributes set. You need to use
DAO to set those attributes.

Here's a field type reference, comparing the field names in the interface
with DDL, DAO, and ADOX:
http://allenbrowne.com/ser-49.html
Footnote 9 addresses your question.

For an example of creating fields in DAO, see:
http://allenbrowne.com/func-DAO.html
The CreateTableDAO() function gives a hyperlink example.