Number Field in Table

[Bob Vance]

Can I stop a record being saved if the number is 0 in a number field in my
table?

 

[Bob Vance]

I suppose >0 in validation rule would do it?

 

[stumac]

Hi Bob,

Open the table in design mode, select the field in question and in the field
properties (at the bottom) enter <>0 in the validation rule line. You can
put text for an error message in the validation text line if you dont want
the standard error message.

Hth
Stu

 

[stumac]

Yeah, unless you are likely to have negative numbers?

Stu