Paul Hartland
paul.hartland at googlemail.com
Tue Jan 8 14:00:52 CST 2013
Just a thought, is the error with Char in Char:Left([keyword],1) the reason off hand that I think of this is that isn't Char a reserved word in Access ? Paul On 8 January 2013 19:43, 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 > -- Paul Hartland paul.hartland at googlemail.com