Hi,
I have some form fields which a calculation is based on when a form is loaded, unfortunately it works randomly.
As per the attached examples, the consultancy rate (unbound) has a quantity (defaulted to zero), the next box is an hourly rate (looked up from a table) and the third box is the quantity x the rate. When the form loads this third value (or one or more of a couple of similar examples) frequently goes to #Type!
The hourly rate always loads and displays OK and I find that if I click in the quantity box, type zero again and tab out it all goes correct.
Any clues would be welcomed.
I have some form fields which a calculation is based on when a form is loaded, unfortunately it works randomly.
As per the attached examples, the consultancy rate (unbound) has a quantity (defaulted to zero), the next box is an hourly rate (looked up from a table) and the third box is the quantity x the rate. When the form loads this third value (or one or more of a couple of similar examples) frequently goes to #Type!
The hourly rate always loads and displays OK and I find that if I click in the quantity box, type zero again and tab out it all goes correct.
Any clues would be welcomed.
Attachments

30.9 KB Views: 20