Text Box Expressions

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

Guest

I'm trying to return the multiple of two fields in a text box using an
expression like
=[Quantity]*[Unit Price] and in form view the control returns #Name?. I've
been through all the help stuff in the application and can't seem to find a
solution. Any ideas?
 
MixMaster said:
I'm trying to return the multiple of two fields in a text box using an
expression like
=[Quantity]*[Unit Price] and in form view the control returns #Name?.
I've been through all the help stuff in the application and can't
seem to find a solution. Any ideas?


Make sure the name of the TextBox is neither "Quantity" nor "Unit Price".
 
Make sure the text box control has a name that is not the same as one of the
field names. You can set/change the name of the control on the Other Tab of
the properties "window".

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top