Too much data validation!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin B - 05 Jul 2006 15:23 GMT

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!

Reply to this Message

Kalyan Reddy - 06 Jul 2006 04:45 GMT

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.

Signature

Kalyan Reddy
Visit http://www.autonomysystems.com

> 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 --
[quoted text clipped - 3 lines]
>
> Please help!

Reply to this Message

Kevin Bogart - 25 Aug 2006 18:52 GMT

Nop,e that option is greyed out...

-KJB

> Hello Kevin,
>
[quoted text clipped - 12 lines]
> >
> > Please help!

Reply to this Message