[AccessD] favor -- someone to run a quick test

    All the four expressions ( in a calculated text box) as given below, return correct name of pertinent bound field (Access 2003) -

=[Form].[RecordsetClone].[Fields](1).[Name]
=[Form].[Recordset].[Fields](1).[Name]
=[RecordsetClone].[Fields](1).[Name]
=[Recordset].[Fields](1).[Name]

A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Susan Harkins 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, February 02, 2007 00:07
  Subject: [AccessD] favor -- someone to run a quick test


  =[Form].[RecordsetClone].[Fields](1).[Name]
   

  =======Gustav and I are working on an article together and the above expression works for him, but not for me. There are no missing references and the RecordsetClone class is present on my system. What this expression does is return the name of underlying fields in a text box control in a form. 
  Just add a text box to any bound form and enter the above expression
  as the Control Source and let me know if it returns the field name or the name? error.  

  I'm using Access 2003 and this is the second name? error that's turned up that I can't explain.  

  Susan H.