[AccessD] #Func! in Access 2010

IIRC it means Access doesn't recognize the function you're calling of
doesn't recognize a argument.  It could come up with a bad reference,
but since removing the -1 from the function allows it to evaluate, I
think it's telling you it can't process the value.  Way back in the
day, those cryptic messages were at the front of the index in the
manuals ... back when they published manuals.  If you still have a 97
reference, check there.

Charlotte Foust

On Wed, Dec 8, 2010 at 12: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
>