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 >