How do I ensure that a certain field value can never be 0?

[rovolution2]

I need to enforce something at the table level which makes sure a certain field value can never be 0. Does this somehow involve the Input Mask, and how would i go about implementing something like this? Thanks

 

[MSAccessRookie]

Take advantage of the "Validation Rule"

To force a numeric value to be <> 0, add "<> 0" as the validation rule. You may also need to define the field as required.

 

[rovolution2]

Use a validation rule for that column:
<>0
If the column can never be null, set the column's required property to yes.

yea i figured this out eventually, but thank you very much for taking your time to answer my question!