A Hyperlink field is a Memo type field, with the Attributes set to:
dbHyperlinkField + dbVariableField
but I don't think Access will let you change the attributes for an existing
field.
To set up the field programmatically would therefore consist of these steps:
1. CreateField() to make a new field of type dbMemo, set the Attribributes,
and Append to the Field of the TableDef.
2. Exeute an Update query statement to update the new hyperlink field with
the contents of the memo field, making sure you include the two # characters
between the components of the hyperlink.
3. Execute a DDL query statement to get rid of the original text field:
"ALTER TABLE MyTable DROP COLUMN MyMemo;"
--
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.
"Andreas Meffert" <an*********@gmx.de> wrote in message
news:42*********************@businessnews.de.uu.ne t...
How can I change the Type of a field in a table from Memo to hyperlink? I
import a table from Oracle to Access 2003. After that, the field type of
some hyperlink-fields is "Memo".
How can I schwitch back to Hyperlink via VBA because its boring doing it
manually often (I import the table each week for doing updates).
When I do it manually the hyperlink works well.