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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set a warning if all text boxes on a form have not been filled in 4
Restrict entering Null or Empty in Textbox - Access 2007 0
Combo Box allows blanks 2
Force the users to enter value in a Text box based on a Combo Box 1
inputting a date into a text box 1
Validation rule for Combo Box 0
Procedure for filling a form with with query result 2
How to validate time format from a text field? 2

Back
Top