How do I update a label with the summary total of six textboxes?

From: Karen Grube (KarenGrube_at_discussions.microsoft.com)
Date: 10/22/04 

Date: Thu, 21 Oct 2004 21:09:02 -0700

Hi!

   I have a web page containing 6 text boxes placed one below the other in a
column. Each textbox accepts only numeric input and is formatted and
validated as numeric.

   As I'm entering each amount, I need to display the summary total of the
amounts that have been entered in a label below the column. I can't seem to
be able to do that! All I want to do is update the text value of the label.
I want for the value of the total to change as the individual amounts are
entered. Below, I'm showing three columns, but really, this is just one
column showing what happens as each of the three amounts is entered.

 ENTRY1 ENTRY2 ENTRY3
120.00 120.00 120.00 <---- This is textbox1
                  240.00 240.00 <---- This is textbox2
                                         230.50 <--- This is textbox3

120.00 360.00 590.50 <--- This is the label I need
to update.

For each of the text boxes, I'm calling the TextChanged event, recalculating
the total and then setting the label text to the string formatted value of
the total. However, the new amount is never displayed on the screen.
Initially, the value of the total is set to zero, and that displays, but is
never updated as the amounts are entered.

These are completely unbound controls, by the way. Do I need to be binding
the label to something or do something in the html code to get the total to
display?

Any exmples or discussion of how to do this would be greatly appreciated.

Thanks!
Karen Grube
klgrube@yahoo.com

Relevant Pages

  • Re: complicated array
    ... If you want to apply a formula system ... 1] Extract a list of distinct accounts and total their amounts. ... which is just a label. ...
    (microsoft.public.excel.worksheet.functions)
  • Grand Totals in a mail merge
    ... I have a catalog type mail merge in Word 2000 that uses a table to display 11 ... Three columns have amounts that are totaled for ... My data source is a filtered Excel spreadsheet. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Criteria not working in DSum function
    ... > I want to display sum of the amounts for a particularID i.e. 246 on a ... > The BlockgrantId field is a number field. ... > However, when the form is displayed, the sum of all the amounts of all ...
    (microsoft.public.access.modulesdaovba)
  • Re: Australian currency question...
    ... > Also, apologies if this is the wrong group, it seemed like the most ... > products priced to use these amounts - the total amount to be paid is ... Purchasing three would be $8.97, ... > display it as 34.75. ...
    (microsoft.public.excel.worksheet.functions)
  • Australian currency question...
    ... Also, apologies if this is the wrong group, it seemed like the most ... Purchasing three would be $8.97, ... I need a function that would allow me to enter amounts for individual ... display it as 34.75. ...
    (microsoft.public.excel.worksheet.functions)