BLANK FIELDS IN FORM

[HerickP]

hi,<br><br><br>I have a form with 5 textboxes, each one bounded to a field of a table. Users will be entering Data on these texboxes, but I do not want them to be able to save the record without having all texboxes filled out ( which means, no blank texboxes allowed). Is there a way I can customize this in code, so for instance, if someone entered data in the PO field, but data was blank or not valid ( a PO number with 7 digits), a msg box would popup saying &quot;Invalid PO number, please try again&quot;....?????? Thanks again!!

 

[DougP]

Of course, there are a couple of options.<br>1. Open your table in Design view where the data is stored for the form and click on a field name. Press F6 which wil take you to the bottom of the design screen and you have several options here Validation Rule and Validation Text<br>click in the Validaion rule box and Press F1. This will bring up help about Validation Rule.<br><br>2. you can do the same on your form Validation Rule and Validation Text.<br>In Design view of the form Double Click on a text box to bring up properties and look for Validation Rule.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.