Decimal Place Issue On Text Control In A Form

[catbeasy]

I have a form that has a text control that calculates a variance as:

=[Grp_Install_TAT]-[txt_Hrs_48]

I have set that text box's decimal places propery to 2.

However, the decimal place value goes as large as the box is. It doesn't appear to work. Any suggestions?

btw, trying to avoid having to write the Format function into the formula if possible..

Thanks for any suggestions..

 

[ajetrumpet]

I have set that text box's decimal places propery to 2.

have you set the FORMAT property appropriate though? like...to general number?

 

[Poppa Smurf]

You will need to set the format property of the text box to Standard or Fixed with the number of decimal places set to 2.

 

[catbeasy]

You will need to set the format property of the text box to Standard or Fixed with the number of decimal places set to 2.

Thanks, this worked. I had it set to general number. I guess it needs to be Fixed.