[AccessD] Nevermind (#Func! in Access 2010)

Offhand, I'd say the minus one is trying to return a negative value on
a field with nothing in it.

Charlotte Foust

On Wed, Dec 8, 2010 at 1:01 PM, Susan Harkins <ssharkins at gmail.com> wrote:
> Nevermind. <groan>
>
> Susan H.
>
>
> 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
>