Decimal places

[MnR]

hi,

I am not sure how to get a field to except an input with 3deciaml places. The user has to basically input a weight (in kg) to the nearest 5g which i think should be 3 decimal places. I need a way to define the field to accept this. Ideally the decimal should be already in the field but it doesn't matter.

MnR

[Slobey]

Any number field will accept this. right click on the field in layout mode and go to "format number". select "format as decimal" with "fixed number of decimal digits" at 3. You can also choose Use "notation" and add the Kg

[QuinTech]

And if you want to enforce entry to at most 3 decimal places, validate the field with:

(tableName::fieldName*1000) = Int(tableName::fieldName*1000)

HTH,

Jerry

[MnR]

Thanks that helps lots!