problem with memo field

[neelesh kumar]

sir,

in my form textboxes named qst,opt1,opt2,opt3,opt4 are there having control sources(question,option1,option2,option3,option4 which are memo fields) from the tblexam.

if isnull(qst.value) or isnull(opt1.value) or isnull(opt2.value) or isnull(opt3.value) or isnull(opt4.value) then
msgbox "invalid"

If i click modify button in my form and make any question or option null then message box is not coming.It is not taking as null.
for text fields it is taking as null but for memo fileds in the table it is not taking as null though i cleared the question or option filed.
why
please help me
thanks in advance
.

[MMcCarthy]

Deleting data doesn't necessarily set the textbox to null. Try this ...

If IsNull(Me!qst) OR Me!qst = "" _
   OR IsNull(Me!opt1) OR Me!opt1 = "" _
   OR IsNull(Me!opt2) OR Me!opt2 = "" _
   OR IsNull(Me!opt3) OR Me!opt3 = "" _
   OR IsNull(Me!opt4) OR Me!opt4 = "" Then
 
   MsgBox "Invalid"
 
End If
 

Mary

[JConsulting]

sir,

in my form textboxes named qst,opt1,opt2,opt3,opt4 are there having control sources(question,option1,option2,option3,option4 which are memo fields) from the tblexam.

if isnull(qst.value) or isnull(opt1.value) or isnull(opt2.value) or isnull(opt3.value) or isnull(opt4.value) then
msgbox "invalid"

If i click modify button in my form and make any question or option null then message box is not coming.It is not taking as null.
for text fields it is taking as null but for memo fileds in the table it is not taking as null though i cleared the question or option filed.
why
please help me
thanks in advance
.

Alternatively
J

If nz(Me!qst,"") = "" OR nz(Me!opt1,"") = "" OR nz(Me!opt2,"") = "" OR nz(Me!opt3,"") = "" OR nz(Me!opt4,"") = "" Then
   MsgBox "Invalid"
End If
 

[MMcCarthy]

Alternatively
J

If nz(Me!qst,"") = "" OR nz(Me!opt1,"") = "" OR nz(Me!opt2,"") = "" OR nz(Me!opt3,"") = "" OR nz(Me!opt4,"") = "" Then
   MsgBox "Invalid"
End If
 

Doh!

I'm too tired to be doing this tonight. How did I miss that. Thanks J.

Mary

[JConsulting]

Doh!

I'm too tired to be doing this tonight. How did I miss that. Thanks J.

Mary

anytime :)
J