Too much data validation!

K

Kevin B

I have a series of numerical fields followed by one which is calculated by a
formula. The problem is that the formula returns an answer with a decimal --
sometimes a two point decimal, sometimes a three. So, I can't define the
number of decimals in the Access database that is driving the form, and I
keep getting data validation errors whenever I try to preview the form.

Please help!
 
K

Kalyan Reddy

Hello Kevin,

You can define the decimal Format in the Infopath.
Open the Field Properties|Data|Data Type, select Decimal(Double),
Click on Format button to open Decimal Format Window
Select the Decimal Places from the Drop down

I hope this will help You.
 
K

Kevin Bogart

Nop,e that option is greyed out...

-KJB

Kalyan Reddy said:
Hello Kevin,

You can define the decimal Format in the Infopath.
Open the Field Properties|Data|Data Type, select Decimal(Double),
Click on Format button to open Decimal Format Window
Select the Decimal Places from the Drop down

I hope this will help You.
Click to expand...
 
Top