Decimal Place Issue On Text Control In A Form

catbeasy

Registered User.
Local time
Today, 08:04
Joined
Feb 11, 2009
Messages
140
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..
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom