[AccessD] ACCESS2003 Function is not Expression

Jim Hewson jm.hwsn at gmail.com
Tue Jan 8 15:37:07 CST 2013


I had a similar error once and traced it to the field and a control had the
same name. Once I changed the control name to something else the error went
away.
Not sure if this is the issue though.
Jim

On Tue, Jan 8, 2013 at 2:58 PM, Charlotte Foust
<charlotte.foust at gmail.com>wrote:

> Is keyword a field in a table or subquery in the query?  You probably need
> to put the full tablename.Keyword reference in there to make it work.
>
> Charlotte
>
> On Tue, Jan 8, 2013 at 11:43 AM, Tony Septav <TSeptav at uniserve.com> wrote:
>
> > Hey All
> >
> > Interesting, if is use
> >
> > 1. First Char:Left([keyword],1) in a query grid it raises an error
> message.
> >
> >  2. MsgBox Left(rst!keyword,1) in a recordset it works fine
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list