contol validation. THank you

[racerrunner]

Hi all,

I've 10 controls that take accept positive number n must be greater than 0.

How do i make sure that the number enter must be greater than 0 immediately after the user enter the value.

One of the way is to do the validation in the control (afterupdate event). However, if I was to do that I would have 10 controls afterupdate events which make my code longer.

Hence, is there any better way to do that?

Thank you.

 

[ejstefl]

Can't you just set the Validation Rule in the control's properties?

 

[RV]

One of the way is to do the validation in the control (afterupdate event)

If you want to use events for validation purposes, it's the Before Update event you should be using.
After Update runs, well, after your date has been updated.
Hence you too late

RV