Douglas,

I removed the reference and the issue still remains. I added vba.left to the
expression and now it says Undefined function 'vba.Left' in expression. Any
more thoughts would be appreciated. Thanks for all your help.

A random thought: Not that I've seen it but could a variable or something
being Dim'ed as "left" be creating this? I would think that could confuse
Access.

--
Message posted via http://www.accessmonster.com