Getting rid of automatic data validation

[Jeffshex]

This is probably easy...but I have yet to figure it out.
My form is attached to my database and in some of these fields, you would
put the amount of hours worked. Well when it comes to hours like 3.5
(anything with a decimal) it red lines the box and says invalid. I've
switched the decimal place in Access to 1, but can't seem to figure it out.

Any ideas?

 

[Scott L. Heim [MSFT]]

Hi,

What is the data type in your Access database? In addition, if you
right-click on the text box in your InfoPath form, choose Properties and
then click the Format button - what is this set to?

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Jeffshex]

Scott,

The data type is set to Number:
Field Size: Double
Decimal Places: Auto

It seems that this is Access doing this...not all Infopath. Access is
rounding the numbers now too.

The format though is grayed out...set to Optional_double.

Hope that helps some.

 

[Jeffshex]

Figured it out. Had to save the form and reopen it. Oddly enough that
allowed me to get into the format under the text box properties. That gave
me access to set the decimal place!

Rock on.

 

[kfrost]

Hello Jeff,

I wanted to add to this thread because I've had similar problems with SQL.
I use decimal and at first I didn't have the scale set properly and once I
changed it in SQL I still had problems. What I found that even though you
change the value in SQL any elements bound to it in Infopath don't
automatically update. The way I go about it is go into my data connection
and remove the columns from any table in which I changed the data format.
Once I complete that I go back through and re add the columns. Then you
replace the elements in the form and then the are updated properly.

Probably a better way to do it but that's what I have to do.