Dimensioning string arrays to take more than 50 chars of data

  • Thread starter Thread starter Margaret Bartley
  • Start date Start date
M

Margaret Bartley

There seems to be a default limit of 50 characters per element in string
arrays.

When I try to move a string longer than 50 characters into a string array, I
get error:
"3163: The field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data."

I don't see any syntax to define the length of a string array. Is there a
way to do this?
 
Unless you specifically created an array of fixed-length strings (unlikely
to do accidentally), the array should handle string up to 64k each.

The error message is about the size of a *field* rather than a string, and
50 char is the default size for Text fields in Access 2003 and earlier. Is
there any chance the code is failing when you try to assign the array
element to the field of a table?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top