In my experience, this is a result of either too many records returned or, more commonly, too many records excluded. I am not sure if there is a specific list recordset size that will generate this error, it is more a combination of things. My solution has always been to go back and simplify the...
Another way if you are specifically trimming a number of characters is:
left(YourField,len(YourField)-3)
This would trim the last 3 characters from the specified field.
Actually, you can display it correctly using this format:
=TEXT(012345678, "000000000")
Or you can set your output to include a ' with the data.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.