[AccessD] ACCESS2003 Function is not Expression

Thanks to all who have responded

It is a simple 

Variable response in a field in the Query Grid

eg - Something: left([Field],1)

 

I have tried the same thing using many different tables. Each query when run
generates the same error message on the client's machine (not mine).  As
mentioned I have his laptop so I can try different scenarios.

As many of you have mentioned (myself included) I have seen this before, but
thinking at the time I would never forget what caused the message I never
wrote it down. 

I do not want any cheese with my "Whine", but Windows 7 security has caused
me endless grief in my coding.  The latest being, on my install I put the
front end in a subfolder in the Program Files (or (x86) )folder, when the
program tried to do a "repair and compact on exit" a message would appear
telling me something like I did  not have ADMIN rights to do this. 

So I had to change my install location for the front end. 

 

This is "mystery meat" and I either solve it or rewrite it to come at it
from a different direction. Ask me if I am frustrated.

 

Thanks Again