[AccessD] which is the difference between...

Hi  Gustav,
yeap...that is

thank's
/kostas

-----Αρχικό μήνυμα----- 
From: Gustav Brock
Sent: Tuesday, October 28, 2014 2:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com