Create variable longer than 255 characters

[jl2886]

I would like to create a text variable that has 255 characters. If it isn't posssible what other options do I have?

[ADezii]

I would like to create a text variable that has 255 characters. If it isn't posssible what other options do I have?

It is possible and what it is called is declaring a Variable as a Fixed Length String. Whatever spaces are not used within the Variable are padded:

Dim strYourVariable As String * 255
strYourVariable = "Philadelphia"

'Philadelphia consists of 12 Bytes while strYourVariable consist of 255 Bytes
'(12 for Philadelphia and 243 'padded spaces')

Debug.Print Len(strYourVariable)      'will output 255

NOTE: A Fixed Length String can contain 1 to approximately 64K (2^16) characters.

[kartikss]

Hi,

If you want to create text variable more than 255 characters then use memo instead of text it has 65535

try this option it might work

thanks & bye

kartik

[missinglinq]

And exactly how would you Dim that variable, kartik?

[ADezii]

Hi,

If you want to create text variable more than 255 characters then use memo instead of text it has 65535

try this option it might work

thanks & bye

kartik

You cannot Declare a Variable as Type Memo - no such animal exists.

[jl2886]

Thanks everyone, I just seperated the variable into a couple different ones.

[ADezii]

Thanks everyone, I just seperated the variable into a couple different ones.

Glad to help.

[kartikss]

And exactly how would you Dim that variable, kartik?

You don't require dim option here. no coding required.

simply create a table you need create field name next to field go to data type and select memo instead of text

Thanks & Bye

Kartik

[Rabbit]

You don't require dim option here. no coding required.

simply create a table you need create field name next to field go to data type and select memo instead of text

Thanks & Bye

Kartik

You misunderstood what missinglinq was talking about. A variable is not the same thing as a field.

A variable is Dimmed through code and as such there is no Memo variable.