On Sun, 12 Jun 2005 11:33:54 +0100, Mike NG wrote:

Does anyone know if there is a large overhead in declaring a variable
length string (which could hold up to 2^31 characters) over a fixed
length string? I assume the memory gets allocated on the fly as 2^31
bytes = 2 GIG, and I only have half a gig of memory. I need to declare
some pretty huge arrays of strings and need to know up front if I am
going to run out of memory or not

I appreciate I'd have to implement my own terminator and length function
like in C. My strings will typically be 16 characters long, but could
go up to say 35 characters long

From the description of data types in HELP for VBA, it looks as if there is an
overhead of 10 bytes/string for variable length strings.


--ron