Query expression becomes myteriously truncated...!

[KevCon]

I have an Access2000 file containing a query that bombs when I try changing the query (on a PC from which I normally work on.
When I change something in the query, it gives me a "missing bracket" example for an existing expression which DOES NOT have a bracket missing, and when I zoom into the text for the expression, it shows me about 50-100 characters LESS what I had in there before I left home! When I get out and don't save changes, it runs fine, but go to design it again, make a change, it gives me this truncated expression again, even when I try to go to SQL view. At some point I was able to work around it, but I think it's a bug! Anyone ever seen this?

 

[tempclerk]

I think there is a limit on expression length just like on a text field (is it allowing 255 characters?) Try breaking it up into separate expressions that you can build on with shorter names, etc.