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
