[AccessD] ACCESS2003 Function is not Expression

I've seen weird things like this when there was a compile error somewhere
else.

Try going into VBA and compiling your code. It will bring up anything that
has issues.

D


On Wed, Jan 9, 2013 at 12:43 PM, Jim Dettman <jimdettman at verizon.net> wrote:

>
>  Generally when you see this, it's references.  However if they are broken,
> it won't work anywhere else either.
>
>  To double check, open the VBA editor, call up the debug window and type:
>
>  ? Left("Tony",1)
>
>  If that works, then references are OK.
>
>  I would then try a query with a single column on that table with left() on
> another field and see if it works.  If it does, then switch to the Keyword
> field.
>
>  Access 2010 BTW is a LOT picker about syntax and where/how things are
> used.
>
>