Using Macros to Create an Error Message

[radguy]

Does anyone know how to use Macros or Expression Builder to create an error message in a form if I am filling out a form and the field is blank? I want to create a Macro or an Expression Builder that won't allow me to move on to the next field without first filling out the field before it.

[ItsMe]

You can adjust the field's properties at the table level to mandate said field has a value before saving the record. Another approach is to use code to maintain constraints. If you enforce constraints at the table level within Access, understand there will be a need to use code and or Options Settings so the Users do not run amuck through a back door.

Here are some VBA examples. It is not a perfect example. I added code to an existing project and did not make ALL of the code my own. Like any project, you need to first consider the needs of the business and then decide what functionality to build into your app.
https://www.accessforums.net/access/...tml#post236414