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

On Wed, 30 Aug 2006 03:45:26 GMT, JoeBlack <(E-Mail Removed)>
wrote:

>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???

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

--

Ken Snell
<MS ACCESS MVP>

"JoeBlack" <(E-Mail Removed)> wrote in message
news:Xns982ED32CE8839joeblack666hellco@198.80.55.250...
> 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