[AccessD] Function references produce #Name? error

John - not too long ago a few of us were discussing new issues in 2003 and one of them was the problem you have described. A couple of others had the same error using 2003.

Being short of time, I solved mine by setting the value of the text box in code rather than as a property of the text box on the form.

HTH

Kath

  ----- Original Message ----- 
  From: John Porter 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, March 28, 2007 8:09 PM
  Subject: [AccessD] Function references produce #Name? error


  When I installed an Access 2003 application on a client's machine, I
  found that, if the control source of a text box is an expression
  including a function reference (e.g. Ucase('a')) the text box displays a
  #Name? error. This happens even if I choose to 'unblock unsafe
  expressions' when opening the app., or set macro security to low.

  Functions evaluate correctly in VBA code. In a new app. created on the
  client's machine, function refs. work OK in a text box, and if I import
  the objects from the problem app., everything works fine.

  I'd be really grateful if anyone could suggest an explanation or
  solution of this problem.

  Regards,    


  John R. Porter
  IT Services
  University of Strathclyde
  Jordanhill Campus
  86 Southbrae Drive
  Glasgow
  G13 1PP
  e-mail: j.r.porter at strath.ac.uk
  Tel.: 0141 950 3289

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