what is in a blank text box???

  • Thread starter Thread starter JoeBlack
  • Start date Start date
J

JoeBlack

If i tab by a text box what is entered in the table and can i test with
validation rules to stop this. ... IsEmpty .. IsNull .. Not "" what???

simple question need simple answer

thanks Joe
 
If i tab by a text box what is entered in the table and can i test with
validation rules to stop this. ... IsEmpty .. IsNull .. Not "" what???
Click to expand...

Null, or the table field Default Value if it has one, will be entered
into the table.

You can test (say in the Form's BeforeUpdate event) with an expression
like

If IsNull(Me.textboxname) Then
<take appropriate action>
End If


John W. Vinson[MVP]
 
If Len(Me.TextBoxName.Value & "") = 0 Then
' the textbox contains "" or Null value
Else
' the textbox contains some other value
End If
 
Back
Top