Salima has attended:
Access Advanced course
Data entry in form
hi
how can restrict a form so it will highlight the field that cannot remain blank. so if the inputter is keying in a data in form and forget to select customer name from dropdown list, form should prompt "please select cutomer"
RE: data entry in form
Hi Salima, thanks for your query. That involves putting data validation on the field in question. You can do this on a table or on the form itself, but it's best practice to do so on the form. Here are a couple of links with further information:
http://office.microsoft.com/en-us/access-help/create-a-validation-rule-to-validate-data-in-a-field-HA010096312.aspx
http://allenbrowne.com/ValidationRule.html
Hope this helps,
Anthony
RE: data entry in form - validation rules not working for new re
Thank you for your reply
i have updated the validation rule and validation text at form level. now the problem is if i go to new record in the form, it will not prompt the validation message and let me through without filling in the mandatory fields but if i go back to existing record and delete the text in mandatory field then before going to previous or next record, it will prompt me to fill in the mandatory field. i really want it to prompt me when i am making a brand new entry in a form. can you please help me to achieve that?
RE: data entry in form - validation rules not working for new re
Hi Salima. Ah, I see. I'm afraid that will involve some code in the background detecting the current status of controls on the forum and responding accordingly to what is being entered. Once you go beyond the out of the box functionality you're into the land of VBA!
Anthony
