Calculations in "unbound" boxes

[Guest]

I have a form that is linked to a table. I created an "unbound" text box on
my form. I am using the expression builder to build simple calculations
(field1/field2). However, my form displays "#NAME?"
Any ideas?

 

[Albert D. Kallal]

Hum, what does the source of the text box look like?

Normally, you need to build a expression like

=([Field1] / [field2])

Try the above.....

 

[John Vinson]

I have a form that is linked to a table. I created an "unbound" text box on
my form. I am using the expression builder to build simple calculations
(field1/field2). However, my form displays "#NAME?"
Any ideas?

Put an equals sign in front of it. Set the control source of the
expression textbox to

=[field1] / [field2]

Do use the square brackets, otherwise it will try to divide the text
string "field1" by the text string "field2" and get REALLY confused!

John W. Vinson[MVP]

 

[Guest]

Ok, I tried it but I am still receiving the error. Any other ideas?

I have a form that is linked to a table. I created an "unbound" text box on
my form. I am using the expression builder to build simple calculations
(field1/field2). However, my form displays "#NAME?"
Any ideas?

Put an equals sign in front of it. Set the control source of the
expression textbox to

=[field1] / [field2]

Do use the square brackets, otherwise it will try to divide the text
string "field1" by the text string "field2" and get REALLY confused!

John W. Vinson[MVP]

 

[John Vinson]

Ok, I tried it but I am still receiving the error. Any other ideas?

No, because I cannot see your database; do not know the names of the
fields in your table; do not know the nature of the Recordsource for
your form; and do not know what you actually have as the expression.

Could you please give us a little help here?

John W. Vinson[MVP]

 

[J. Goddard]

Is the name of the text box the same as a field in the table? That can
sometimes cause #NAME, in fact if [field1] or [field2] is the name of a
form control and also the name of a table field in the form's source,
you may get this.

John

Ok, I tried it but I am still receiving the error. Any other ideas?

:

I have a form that is linked to a table. I created an "unbound" text box on
my form. I am using the expression builder to build simple calculations
(field1/field2). However, my form displays "#NAME?"
Any ideas?

Put an equals sign in front of it. Set the control source of the
expression textbox to

=[field1] / [field2]

Do use the square brackets, otherwise it will try to divide the text
string "field1" by the text string "field2" and get REALLY confused!

John W. Vinson[MVP]

 

[Guest]

Ok.
The table name is Kent, which the form is pointed to. My expression is "=
[Kent]![Volumes] / [Kent]![Labor Hours] " I am using an unbound text box
named "text 453"
Thanks.

 

[John Vinson]

Ok.
The table name is Kent, which the form is pointed to. My expression is "=
[Kent]![Volumes] / [Kent]![Labor Hours] " I am using an unbound text box
named "text 453"

Leave off the tablename and the !.

John W. Vinson[MVP]