I’m back with another Access tip. This time, I’ll explain how to require information in a field in your forms. There’s a lot of information that can be collected within a company. Not all details are equally important, though, so you’ll want to make sure you do get the most important information. That’s where required fields come in handy.
Imagine you’re creating an Access form to collect information about your products. It’s important for each product to be easily identifiable, so you create a field (control) in which employees need to enter the product code: if they haven’t entered the code, they can’t send in the form. You can do this by requiring a value in that field. This is how you do it:
- Open your table in Design view (see Home).
- Click the field or control containing the product code.
- Click Yes next to the Required property in the General tab.
That’s it. If someone forgets to enter the product code now, they won’t be able to complete the form.
Want to know more about table properties in Access? Make sure to sign up for our training: Access: 1. Creating Databases..