Forum home » Delegate support and help forum » Microsoft Access Training and help » Data entry in form
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Data entry in form
Resolved · Urgent Priority · Version 2007
Reply Thu 10 Nov 2011, 11:16Delegate Salima said...
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"
For upcoming training course dates see: Pricing & availability
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
Reply Fri 18 Nov 2011, 16:52Delegate Salima said...
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
Sun 27 Nov 2011: Automatically marked as resolved.
|