[AccessD] ACCESS2003 Function is not Expression

Charlotte Foust charlotte.foust at gmail.com
Tue Jan 8 14:58:13 CST 2013


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
>


More information about the AccessD mailing list