adding a memo field programatically

[alfred]

Hi

What is the type of a memo field and a long integer.
ex. double = adDouble, currency = adCurrency etc.
text = advarwchar
Set col16 = Nothing: Set col16 = New ADOX.Column
With col16
.Name = "PackMemo"
.Type = adVarWChar
.DefinedSize = 50
.Attributes = adColNullable
End With
Thanks for help

[David Lloyd]

Alfred:

For a memo field, I believe the adLongVarWChar constant is the equivalent.
For a long integer, use adInteger, which represents a four byte integer. An
Access integer is represented by the adSmallInt constant.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"alfred" <al***********@hotmail.com> wrote in message
news:dd**********@ctb-nnrp2.saix.net...
Hi

What is the type of a memo field and a long integer.
ex. double = adDouble, currency = adCurrency etc.
text = advarwchar
Set col16 = Nothing: Set col16 = New ADOX.Column
With col16
.Name = "PackMemo"
.Type = adVarWChar
.DefinedSize = 50
.Attributes = adColNullable
End With
Thanks for help