Calcuating the Text Value of Text Box's

[tm1274]

I have 2 text fields, the first named Price1 (id 1004), the second named Price2 (id 1006) and a total field named Total (id 1008) and I am trying to create a script to automatically put the total in the Total text field when the user changes the text in one or both of the text fields. I have looked at what I believe to be nearly all change events and have found that the on selectionChanged seems to work best but still not very good. I am trying to script an automatically totaling text field something like this:

Code: Select all

on selectionChanged
     put field id 1004 + field id 1006 into field id 1008
end selectionChanged 

However, the only time it changes is when the user selects the total field and I assume this is due to the script being in this field.

Is there a better simple way of doing this, something that does not require a button to initiate the event and that will automatically change the total based upon the text values in the text fields?

[mwieder]

I assume this is due to the script being in this field.

That's correct. Put the code into the scripts of the source text fields instead and you should have what you're looking for.

[tm1274]

Thanks for the fast response.

Ok, by placing the code in the script of both the Price1 and Price2 fields I get a similar result. When I change the text in Price 1 the total does not change until I place my cursor in the Price2 field or if I change the Price2 field the total will not update until the cursor is placed in the Price1 field.

Is there a way to avoid this behavior? I would like to somehow update the total based upon individually updating a text field rather than forcing the user to either click a button or place their cursor in the next text box.

[mwieder]

Yeah, the selectionChanged event won't trigger until you move from the current field. So you might want to trigger on various key events:

Code: Select all

on keyUp
  recalculate
end keyUp

on backspaceKey
  recalculate
end backspaceKey

on recalculate
  put field id 1004 + field id 1006 into field id 1008
end recalculate

[tm1274]

That appears to have worked. I have nearly went bald trying to make this work. Thanks for all your help..

[mwieder]

I have nearly went bald

Not to worry... some of us have trod *that* route beforeyou... <g>