InfoPath Text Box Number Rounding - Please Help

[Tino]

Hi

I've created an invoicing based form template that
connects to an Access 2003 database. In the database
there is a Quantity Shipped Field that is of the "double"
datatype and requires resolution to 1 decimal place (ie.
600.5 or 600.0 etc).

The Quantity Shipped field is in a repeating table.

The problem I have is that InfoPath keeps rounding up or
rounding down the inputted number making the form's
printout invalid. I've looked at the properties of the
text box and cannot change its formatting (its greyed
out) and whatever I do in the database it makes no
difference.

Can anyone help me please....its driving me nuts !!!!

Thanks

Tino

 

[Jerry Thomas [MSFT]]

You should be able to set the number of decimal places.
Field name and Data type are 'locked', but Format is not.

--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.