Break up long "if" statement, How?

[Meltdown]

How do I break up a long statement like this:

If Not IsNull([Forms]![frmCustomerReports2]![clinica].[Value]) And _
IsNull([Forms]![frmCustomerReports2]![aalto].[Value]) And _
IsNull([Forms]![frmCustomerReports2]![other].[Value]) And Not _
IsNull([Forms]![frmCustomerReports2]![Combo15].[Value]) And _
IsNull([Forms]![frmCustomerReports2]![Combo12].[Value]) And Not _
IsNull([Forms]![frmCustomerReports2]![Text1].[Value]) And Not _
IsNull([Forms]![frmCustomerReports2]![Text3].[Value]) Then
MsgBox "correct number of values"
Else
MsgBox "Incorrect number of values"
End if

the above doesn' t seem to work

Thanks for any help

 

[chewy]

what doesnt work?

 

[Rob.Mills]

Pat,

Would a For Each... Next work better here? Just have it cycle through all textboxes and determine if they all have data or not?

 

[Meltdown]

A reply from the great man himself...thanks Pat