requiring non null field values in a form or query

Is there any way I can require that a field have a non-null value in a form
or query?

I know how to do this in a table definition by setting the Required property
to Yes, but I don't want to do this in the table definition. I need to do
it in either a form or query.

Any suggestions about this?

Thanks in advance,

Paul

Paul, you could set the before update event of the form to check the field.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.MyControl) Then
MsgBox "Can't be null"
Cancel = True
Me.MyControl.Setfocus
End If
End Sub


--
Reggie

----------
"Paul James" wrote in message
...
Is there any way I can require that a field have a non-null value in a
form
or query?

I know how to do this in a table definition by setting the Required
property
to Yes, but I don't want to do this in the table definition. I need to do
it in either a form or query.

Any suggestions about this?

Thanks in advance,

Paul

Thanks for your help with this, Reggie.

A question: do I need to be concerned with zero-length strings, or will If
IsNull(Me.MyControl) work for those as well?

Paul

Paul, If your field allows zero length strings change your statement to

If IsNull(Me.MyControl) Or Me.MyControl = ""

--
Reggie

----------
"Paul James" wrote in message
...
Thanks for your help with this, Reggie.

A question: do I need to be concerned with zero-length strings, or will If
IsNull(Me.MyControl) work for those as well?

Paul

A shorter way to check both zero-length string and Null is this:

If Len(Me.MyControl & "") = 0 Then
' the value is either Null or empty string

Else
' the value is not Null and not empty string

End If


--

Ken Snell
MS ACCESS MVP

"Reggie" wrote in message
...
Paul, If your field allows zero length strings change your statement to

If IsNull(Me.MyControl) Or Me.MyControl = ""

--
Reggie

----------
"Paul James" wrote in message
...
Thanks for your help with this, Reggie.

A question: do I need to be concerned with zero-length strings, or will
If
IsNull(Me.MyControl) work for those as well?

Paul

Thanks, guys.

Paul