I have a similar problem but sadly that is not the fix for me. I already had my query programmed in that way but I am still experiencing a problem. As this is just testing, I am going to post my code below:
SELECT Len([MAIN].[ADDRESS]) AS LEN, MAIN.ADDRESS
FROM MAIN
WHERE...