Why cant i get 2 decimal places

[bunji]

I would like the users to enter values of day 2.5 however it always rounds up to 3 i have checked the propeties of the field in the table and i have set it to 2 decimal places. I have also checked the property of the field on the form and done the same. There must be something i am missing.

Thanks for lookin gand your help.

 

[allan57]

Bunji, try the following

Under form field properties make sure that 'Format' property = Standard, this should then activate the 'Decimal Places' property that you had previously set.

Allan

 

[Mile-O]

You probably have your field set to the default Long Integer. Since an integer can't have decimal places the Decimal Places property is redundant. Change Long Integer to Single.

 

[bunji]

thats the one!!! thanks alot

 

[bunji]

sorry SJ you replied as i did Allan's worked

 

[Mile-O]

Allan's worked

Are you sure? Since the Format property only affects the way something is displayed and not how it is stored I can't see how you could get 2.50 in a field if it was defined as a Long Integer with 2 decimal places.