[AccessD] which is the difference between...

Hi Kostas

That's because your expression returns Null if all fields are Null.

The third would work as well:

If Len(Nz(Me.paratiriseis)) = 0 Then

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Kostas Konstantinidis
Sendt: 28. oktober 2014 12:39
Til: Access Developers discussion and problem solving
Emne: [AccessD] which is the difference between...

hi all,
[paratiriseis] is an unbound text like:
=[paratirisi_1_tr]+Chr(13)+Chr(10) & [paratirisi_2_tr]+Chr(13)+Chr(10) &
[paratirisi_txt]+Chr(13)+Chr(10) & [paratirisi_txt1] and parat_lbl just a label

so I wonder why the first works while the other two are not!
-----------------------------------
If IsNull(Me.paratiriseis) Then
   Me.parat_lbl.Visible = False
else
...
end if
-----------------------------------
If Me.paratiriseis = 0 Then
   Me.parat_lbl.Visible = False
else
...
end if
-----------------------------------
If Len(Nz(Me.paratiriseis)) = null Then
   Me.parat_lbl.Visible = False
else
...
end if
-----------------------------------

thank you
/kostas