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]

Re: adding a memo field programatically

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" <alfredminnaar@ hotmail.com> wrote in message
news:ddb2s0$ca5 $1@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