[AccessD] #Func! in Access 2010

Carolyn Johnson cjlabs at att.net
Thu Dec 9 08:58:30 CST 2010


Does the database have a reference to DAO?

Carolyn Johnson
St Louis, MO
  ----- Original Message ----- 
  From: Susan Harkins 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, December 09, 2010 8:58 AM
  Subject: Re: [AccessD] #Func! in Access 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 

  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com


More information about the AccessD mailing list