Susan Harkins
ssharkins at gmail.com
Thu Dec 9 08:58:31 CST 2010
Yes, that was exactly it Gary. I had two fields, Name and I don't remember the second, but in the Name field, I somehow managed to enter "Name" as the first entry -- and the second field, the one with the expression, returned that error. The expression does return #Error if the name entry doesn't contain a space, but in that first record, it return #FUNC!, which I don't recall ever seeing before. This only happens in 2010 and interestingly, the query displays #FUNC! in both fields, the Name field and the expression field. In addition, it happens with any one-word entry, not just "Name." So, interesting, and does seem to be related to the no-space error, but why it behaves so different in 2010 is a puzzle to me. Changing the Name field name didn't resolve it. So, now you know as much as me -- I stopped exploring. I don't mind a new error value -- learn new stuff every day. The true puzzle is why it won't display the actual name entry in the Name field when there's no space -- it too displays the #FUNC! error value instead of the actual entry -- which is really curious. Susan H. >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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com