Hello. Is there a variable that 1

[SteveCarrier]

Hello.

Is there a variable that will hold more data than a String? I need a variable that will concatanate a massive string together so that I can combine many fields and then dispense them into a memo field I made.

Thanks in advance.

Steve Carrier

 

[AWithers]

You could use a string array and then loop through each item and update the memo field or alternatively rather than concatenate them together in code you could update your memo field using consecutive updates as follows:

update yourtable
set yourmemofield = yourmemofield+" "+nextstring

change nextstring on each append to the string variable you have

Andy