Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Required field

Status
Not open for further replies.
ZX188

ZX188

Technical User
Mar 30, 2001
21
US
How would I make a field on a form required without setting the required proprities at the table level
 
Sort by date Sort by votes
You could code the Form's Before Update event.

If IsNull(YourField) Then
MsgBox "Data is required."
YourField.SetFocus
Cancel = True
End If
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
181
clevercat88
clevercat88
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
444
atadbitslow
atadbitslow
BradCustom
  • Locked
  • Question
Form Field limited to 255 characters
3 4 5
Replies
98
Views
1K
Andrzejek
Andrzejek
hudsma1
  • Locked
  • Question
how to make field value start with area code
Replies
2
Views
182
zandsc1
zandsc1
Lisa_Sunshine
  • Locked
  • Question
Drag & Drop Outlook Mail to Access memo field issues
Replies
0
Views
115
Lisa_Sunshine
Lisa_Sunshine

Part and Inventory Search

Sponsor

Back
Top