Error #Name?

[christie]

An Access 97 report that has always worked, now prints #Name? in all the text fields that contain the format() or trim()functions in their control source. Printer captures were installed recently, but that's the only change made to the PC. I'm not sure if that has anything to do with it, because the report works on some machines and not on others, all of which have the new captures.

I would greatly appreciate any suggestions,
Christie

 

[mrabrams]

From the Help File:

#Error? or #Name? may appear in a control for a number of reasons. To correct the problem, do the following:

· Make sure that the field specified in the control's ControlSource property hasn't been removed from the underlying table, query, or SQL statement.
· Check the spelling of the field name in the control's ControlSource property.
· If you specified an expression in the control's ControlSource property, make sure that there is an equal sign preceding the expression.
· Make sure that there are brackets around references in expressions to control or field names that include spaces. For example, to subtract a Shipped Date field from a Required Data field, enter the following expression: =[Required Date]-[Shipped Date].

· If you are using one of the built-in functions, make sure that you're using the right number of arguments, that the arguments are in the right order, and that you haven't left out any necessary punctuation. To determine the correct syntax to use, see the Help topic for the function you're using.
· If you are referring to another control, make sure that you're using the correct syntax. For more information on referring to controls, click .

· Make sure that there isn't a circular reference to a control. For example, if you specify MyControl in the Name property of a control, and then type =[A]++[MyControl] in the ControlSource property box for the control, Microsoft Access can't process the expression.

 

[mrabrams]

I clicked submit too fast.
There are so many reasons, that's why I printed them all.

Usually when I get the #Name it's because I changed the name of a control, or deleted and added a control.

Good Luck!

Michael Abrams

 

[norm]

Christie,

Another possibility and also admitted 'bug' (i think) with Access 97 is that #Error message when a control has the same name as the underlying data control source.

for example,the control:
NJ_CEILING

with a control source of:
=2*([NJ_CEILING])

yields:
#Error

...in a report. I pulled many a hair out before I read that finally in Access 97 Developer's Handbook, by Litwin....

rock on.

norm