Size of string

[Roy Goldhammer]

Hello there

In some cases i stuck with strings that is bigger then the string object.

1. How many characters can i place on single String object?

2. In some cases i can't use string functions like: &, mid , instr ect....

What are the limits of string object?

 

[Marshall Barton]

Hello there

In some cases i stuck with strings that is bigger then the string object.

1. How many characters can i place on single String object?

2. In some cases i can't use string functions like: &, mid , instr ect....

What are the limits of string object?

It's not clear what you mean by "string object".

Some of these are version dependent, but in AXP:

A string type variable can be up to 2GB.

A textbox bound to a Memo type field will allow a
user to enter 64K characters, but you can assign
up to 2GB using VBA to a text box.

A Text type field can hold up to 255 characters.