More than 255 characters

[supervi]

In my VB code i have a variable of type string. I concat it to a lot of text and i am worried that it might be larger than 255 characters. Is their a way for me to set this string varaiable to have more than 255 characters?

Should i declare it as type memo cause that doesnt seem to work

Any help would be appreciated

 

[fkegley]

I thought in VB a string could be billions of characters in length. Only the first 255 would be stored in a type Text field in an Access table, however. Memo in Access table only stores roughly 65000, so that may not be big enough either.

Frank kegley
fkegley@hotmail.com

 

[supervi]

Thanks for clearing things up