#Name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know why when I insert a calculated value into a form I am designing, I am getting a #Name? display in the field, even when the calculation is as simple as =[Number1] + [Number2] where number1 and 2 are fields in the table the form is based on?
I cannot get any kind of calculations to work, even though I have followed the Help directions to the letter. What is wrong?
 
One possibility is a broken reference.

Take a look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;283806.

The other possibility is a name conflict. Both the form and report wizards
like to name bound text boxes with the field name they are bound to. Try
renaming the text boxes. I.e., name the text box for field Number1 as
txtNumber1 and the text box for field Number2 as txtNumber2.

Let us know if either of these work.

Good luck.

Sco

Dexter Crawford said:
Does anyone know why when I insert a calculated value into a form I am
Click to expand...
designing, I am getting a #Name? display in the field, even when the
calculation is as simple as =[Number1] + [Number2] where number1 and 2 are
fields in the table the form is based on?
I cannot get any kind of calculations to work, even though I have followed
Click to expand...
the Help directions to the letter. What is wrong?
 
Back
Top