Set Field = tdf.CreateField("Field", dbText, 16) 1

[rgbanse]

Thx in advance
what is the syntax for creating hyperlink field.
Using the following creates a text field ok but I also need to create a hyperlink field

Set Field = tdf.CreateField("Field",dbText, 16)

thx
RGB

 

[RickSpr]

Only Memo fields can be hyperlinks. Change this to:

    Set Field = tdf.CreateField("Field", dbMemo)
    Field.Attributes = Field.Attributes Or dbHyperlinkField

Rick Sprague

 

[rgbanse]

Rick,
It worked perfectly - I tried to give you a star but it came back with a diagnostic error.
I'll keep trying though to get you the star you derserve.
thx
RGB