emptyness in a label problem 2

[virginie]

i have a condition :
If commitdate = null Then
----
---
end if

commitdate is really empty label with null value
but it is not enter the if statement !
i try If commitdate = "" Then
but the result is the same

what can i do to check if there is a value in this label??

 

[AyJayEL]

Is it something like

If commitdate = null then ""
else commitdate

? Learn something new every day *:->*

 

[GHolden]

You could try using

If LenB(Label) > 0 Then
'Not null stuff
End If

of

If Label = vbNullString Then
'Null
End If

There are two ways to write error-free programs; only the third one works.

 

[KenReay]

Hi

If commitdate is a label control, you need to test commitdate.Caption, if it is a textbox control then try If IsNull(commitdate), if it still doues not work, are you sure it does not contain a space? in which case try

if len(trim(Nz(commitdate,"&quot& "&quot) = 0 Then Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[virginie]

thanks!!

i use IsNull(commitdate), and it works!

 

[AyJayEL]

A star for you Ken! Learn something new every day *:->*