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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"comfrey" <(E-Mail Removed)> wrote in message
news:5EFA346D-3454-4E05-BF7B-(E-Mail Removed)...
> 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.