Form Help

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

Bill Davis

I have 13 text boxes on a form that a number will be
entered and one text box that will calculate the sum of
the other 12. What I need to do is have each text box
have a dollar amount assigned to it ex. textbox 1= 150,
textbox 2=165, textbox 3=180.
How do I code the textbox to represent there value and
keep the entered value as entered if you enter 2 in box 1
it will show the 2 but [textbox 13] will show $300. How
do I code textbox 13 to sum textbox 1-12. If this is
possible?
Thanks in advance
[textbox 1] [textbox 2] [textbox 3]
[textbox 4] [textbox 5] [textbox 6]
[textbox 7] [textbox 8] [textbox 9]
[textbox 10] [textbox 11] [textbox 12] [textbox 13]
 
Bill,
Not sure if I understand...
Is Textbox1 a "quantity" of 150... so that a 3 in textbox1 would
represent 450 OR a 5 in text1 would be 750?
If so... set the ControlSource of TextBox13 to....
= [TextBox1]*150 + [TextBox2] * 165 + [TextBox3] * 180... etc... for
all textboxes
 
Al,
This is working, but not all fields will populate and
when I dont have a entry it does not give me a total..
What can I do about that?
thanks Bill
-----Original Message-----
Bill,
Not sure if I understand...
Is Textbox1 a "quantity" of 150... so that a 3 in textbox1 would
represent 450 OR a 5 in text1 would be 750?
If so... set the ControlSource of TextBox13 to....
= [TextBox1]*150 + [TextBox2] * 165 + [TextBox3] * 180... etc... for
all textboxes
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH

I have 13 text boxes on a form that a number will be
entered and one text box that will calculate the sum of
the other 12. What I need to do is have each text box
have a dollar amount assigned to it ex. textbox 1= 150,
textbox 2=165, textbox 3=180.
How do I code the textbox to represent there value and
keep the entered value as entered if you enter 2 in box 1
it will show the 2 but [textbox 13] will show $300. How
do I code textbox 13 to sum textbox 1-12. If this is
possible?
Thanks in advance
[textbox 1] [textbox 2] [textbox 3]
[textbox 4] [textbox 5] [textbox 6]
[textbox 7] [textbox 8] [textbox 9]
[textbox 10] [textbox 11] [textbox 12] [textbox 13]
Click to expand...


.
Click to expand...
 
Bill,
Try this... it should work. It's the nulls that are the problem.

= Nz([TextBox1])*150 + Nz([TextBox2]) * 165 + Nz([TextBox3])
etc.....

If your a TextBox is Null, Nz will return 0.
Check out Nz function in Help... very useful.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH


Bill Davis said:
Al,
This is working, but not all fields will populate and
when I dont have a entry it does not give me a total..
What can I do about that?
thanks Bill
-----Original Message-----
Bill,
Not sure if I understand...
Is Textbox1 a "quantity" of 150... so that a 3 in textbox1 would
represent 450 OR a 5 in text1 would be 750?
If so... set the ControlSource of TextBox13 to....
= [TextBox1]*150 + [TextBox2] * 165 + [TextBox3] * 180... etc... for
all textboxes
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH

I have 13 text boxes on a form that a number will be
entered and one text box that will calculate the sum of
the other 12. What I need to do is have each text box
have a dollar amount assigned to it ex. textbox 1= 150,
textbox 2=165, textbox 3=180.
How do I code the textbox to represent there value and
keep the entered value as entered if you enter 2 in box 1
it will show the 2 but [textbox 13] will show $300. How
do I code textbox 13 to sum textbox 1-12. If this is
possible?
Thanks in advance
[textbox 1] [textbox 2] [textbox 3]
[textbox 4] [textbox 5] [textbox 6]
[textbox 7] [textbox 8] [textbox 9]
[textbox 10] [textbox 11] [textbox 12] [textbox 13]
Click to expand...


.
Click to expand...
Click to expand...
 
Al,
It works..
Thank you very much..
-----Original Message-----
Bill,
Try this... it should work. It's the nulls that are the problem.

= Nz([TextBox1])*150 + Nz([TextBox2]) * 165 + Nz ([TextBox3])
etc.....

If your a TextBox is Null, Nz will return 0.
Check out Nz function in Help... very useful.
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH


Al,
This is working, but not all fields will populate and
when I dont have a entry it does not give me a total..
What can I do about that?
thanks Bill
-----Original Message-----
Bill,
Not sure if I understand...
Is Textbox1 a "quantity" of 150... so that a 3 in textbox1 would
represent 450 OR a 5 in text1 would be 750?
If so... set the ControlSource of TextBox13 to....
= [TextBox1]*150 + [TextBox2] * 165 +
Click to expand...
[TextBox3]
* 180... etc... for
all textboxes
--
HTH...
Al Campagna
Candia Computer Consulting
Candia, NH

"Bill Davis" <[email protected]>
Click to expand...
wrote
in message
I have 13 text boxes on a form that a number will be
entered and one text box that will calculate the sum of
the other 12. What I need to do is have each text box
have a dollar amount assigned to it ex. textbox 1= 150,
textbox 2=165, textbox 3=180.
How do I code the textbox to represent there value and
keep the entered value as entered if you enter 2 in box 1
it will show the 2 but [textbox 13] will show $300. How
do I code textbox 13 to sum textbox 1-12. If this is
possible?
Thanks in advance
[textbox 1] [textbox 2] [textbox 3]
[textbox 4] [textbox 5] [textbox 6]
[textbox 7] [textbox 8] [textbox 9]
[textbox 10] [textbox 11] [textbox 12] [textbox 13]



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top