I have a form that a user opens to add a new record to the database. I want to make certain fields required data. Is there an easy way to do this, or do I have to do the

If txtfield1 is null then
Msgbox "This is a required field"
txtfield1.setfocus
end if


routine when they try to save the record?

Check out this link in the Code Archive. It worked well for me.

Required Fields

Is is Me!txtfield1 and I personally like that way it is one of the better to check. If you check the data from several different point, like cmdButtons, or have the same data on everal different form then use a function to do this. hth.

Thanks all. When I tried to open the second demo database, I get a read-only message and the database doesn't open. Is this normal?

Try holding down the shift button when open it. hth.

I'm not sure, I used the first attachment as I have Access 2003.

I have Access 2000 and the shift key suggestion does not work either, but thanks for the info anyway!

Oops I found another problem. One of the fields I have formatted as short date. If no value is input in this field, I get a Type Mismatch error. This prevents my required field checks from running when the Save Record button is clicked. How do I get around this?

I generally don't allow date fields to be null (when I can help it) and use a default of Now(). If it is a requirement to leave the possibility of a null, I'm not sure.

This is a form that tracks various job phases, so some of the date information is not available when the initial entry is made. Using a default date field will cause reporting problems.