[AccessD] #Func! in Access 2010

I wonder if your field name "Name" might be a problem?  Reserved word
maybe?  Try renaming to FullName?

It does work fine in A2007 in my testing.

GK

On Wed, Dec 8, 2010 at 2:37 PM, Susan Harkins <ssharkins at gmail.com> wrote:
> Does anyone know what #Func! means? I can't find a reference to it anywhere.
>
> In Access 2010, I'm using a simple parsing expression:
>
> FirstName: Left([Name],InStr([name]," ")-1)
>
> and this value shows up just below the field header in Datasheet view. If I remove the -1 component, #Func! disappears.
>
> Anybody know what this is?
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com