[AccessD] Function references produce #Name? error

John Porter j.r.porter at strath.ac.uk
Wed Mar 28 05:09:39 CDT 2007


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




More information about the AccessD mailing list