Yes, if you've got anything named Left in your application (a table, a field
in a table, a variable, a function, a module, etc.), Access is likely to get
confused.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"The Joker via AccessMonster.com" u17775@uwe wrote in message
news:8043cc83e403d@uwe...
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