Invalid data error with text box calculations

pablavo — Thu, 19 Mar 2009 12:54:27 GMT

Hi there,

This is a short one and I hope someone has come accross this as well.

I have a text box (txtAmount) which has a calculation for its value. The calculation multiplies two fields together.

One field stores a number of days (Days) worked by someone. This is stored as a decimal. The other stores Currency amounts. (Costs). Sometimes depending on the Currency amount I get an "Invalid Data' error around txtAmount. For example, if (Days) has the value 1.2 and it multiplies £471, I get the error. If (Days) is 1.75, I don't get the error.

The calculation is this:

@Days * @Cost

Does anyone know why this is and if there's anything I need to do to prevent this error.

Thanks for any help.

Code

Invalid data error with text box calculations