Keeping a Comment with only blank spaces from creating a record

[jlathem]

Can anyone suggest how I can keep a record from being created in a comment table if if the “Comment” text box is blank or only has blank spaces in the text box?

 

[PHV]

In the BeforeUpdate event procedure of the form:

If Trim(Me![txtComment] & "") = "" Then
  MsgBox "Please enter a comment"
  Cancel = True
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jlathem]

Thank you for your help. That worked for me.

James