Required Input with VBA

[jlgray0127]

Hello all!
Can someone help me with this code? (below)
In the first field in my form, the user is required to enter the name of the project. I do not want the user to be able to leave this field, without entering this information.
I'm not sure what is wrong with the code below, but it is not working.

Private Sub Program_Name_BeforeUpdate(Cancel As Integer)
If Len(Trim(Me.Program_Name)) & vbNullString = 0 Then
MsgBox "You must enter the Program Name.", vbInformation & vbOKOnly, "Entry Required"
Cancel = True
End If
End Sub

Can you please help?
Thank you!

[pbaldy]

The problem with the before update event is it only fires if the user changes something ("updates" the data). I personally would use the before update event of the form. Alternatively you might disable other controls until the user enters something in this one.