How to define a memo field 1

[easycode]

i just need to define a memo field by code

Dim myvar as string
Dim myvar2 as Memo ---> (This datatype does not work)


instead of memo, there's gotta be another keyword

Can anyone advise?

thanks in advance

 

[Golom]

Why not just use string? It can hold ~2 billion unicode characters.

 

[easycode]

i though string was only up to 255 chars

Thanks Golom

 

[Golom]

A String or Text field in a database table is 255 characters. In a VB program however, a String variable type is ~2 billion characters (however fixed length strings are limited to 65535 characters.)