Require Data for Unbound Text Box

[jhabey]

Greetings,
I have an unbound text box on a form that requires user input before pressing an update button that updates a table. How can I:
1) ensure data gets entered
2) ensure data integrity. Value entered should be a number 5 digits in length
Thanks

 

[PHV]

Do the integrity check in the Click event procedure of your update button.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886