I have a form I have been using for a while now that retrieves and saves data to a sql server database. I have a master detail relationship set up.
One of my fields in the DB is of Type real. It is of type "option_float" in infopath 2003. I would like to display 2 decimal places but the form is not showing 2 decimal places.
When I go into Text box properties for this display field the "FORMAT" Button is greyed out and it will not allow me to set the number of decimals.
Does anyone know why this might be?
If I start out and try to recreate this form from scratch again the Format button is not greyed out.
Thank for any help.
Mark