[AccessD] Adding Hyperlink field using DAO

I need to add a hyperlink field to a table using DAO.  I tried the following, but received an error.

Set fld = tbl.CreateField("EstimateSpreadsheet", dbHyperlinkField)

Apparently, I need to create the field as "Memo" and set the attributes to dbHyperlinkField.  When adding a field to a table in Design view, I can select data type Hyperlink.  Why can't I do this in code?  Or can I?  I have a "master" database (which I add/update fields in Design view).  There are several other databases in which I want to propagate (using DAO) changes from the master. 

How can I do this? I am using Access 97.

Thanks,
Barb Ryan