Hi,

I am using Access 2k, and I have a memo field. I am displaying it to the user in Access 2k via code and a listbox. The code uses variants to get data from the tables/array to the list box.

I'vee stepped through the code and the correct full data is returned and stored in the array. But when this is put into a variant then returned via the listbox its truncated to 255 chars.

Is there a string limit to the variant and if so how would I extend it to make the variant a proper string in these cases?

Anyone come across this before?

Vince