[AccessD] #Func! in Access 2010

I do get a #Error on records with no space in the Name field though.

On Thu, Dec 9, 2010 at 8:22 AM, Gary Kjos <garykjos at gmail.com> wrote:
> 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
>



-- 
Gary Kjos
garykjos at gmail.com