Validation error on Number field

[Sam Marillac Clinic]

I have created a Purchase order form for my company in Infopath 2003 attached
to a Access data base. In the Item order repeating section the total field
for each line of items gets a red validation error when ever you enter
curtain Qunatity number and price of the Item.

Example: 3 items of memory sticks with a price of 16.35 each gives a
validation error. If I change the quantity to 1, 2, 4 or more the validation
error disappears.

The Quantity field is a Integer, and the Item price is a number field set to
currency, along with the Subtotal field and Grand Total field. In infopath I
have set the properties decimal place to 2. I have no validation rules set
in my form.

Anyone have any idea on why this would be happening?

 

[sboyd]

I have created a Purchase order form for my company in Infopath 2003 attached
to a Access data base.  In the Item order repeating section the total field
for each line of items gets a red validation error when ever you enter
curtain Qunatity number and price of the Item.

Example:  3 items of memory sticks with a price of 16.35 each gives a
validation error.  If I change the quantity to 1, 2, 4 or more the validation
error disappears.

The Quantity field is a Integer, and the Item price is a number field setto
currency, along with the Subtotal field and Grand Total field.  In infopath I
have set the properties decimal place to 2.  I have no validation rulesset
in my form.

Anyone have any idea on why this would be happening?

Not sure how the formats are in Access but in SQL, I have a field that
is formatted as decimal 5, precision 9 and scale at 2. I had similar
validation problems submitting to an SQL database.

 

[Rick]

Not sure how the formats are in Access but in SQL, I have a field that
is formatted as decimal 5, precision 9 and scale at 2.  I had similar
validation problems submitting to an SQL database.- Hide quoted text -

- Show quoted text -

I am having the same exact problem with a form I created in InfoPath.
I have the form connected to a Microsoft Access database.

I created a formula that sums two currency fields. When the two
fields are $128,897.37 and $11,311.80 - I receive a validation error.
When I change just one of those numbers by one cent, the validation
goes away. This error is driving me crazy!!! Please help


Rick