Try this one:
If isNull(x) Then ' where x is the variable to be checked whether it
has a value
'Hide the column
End If
or...
If trim(x) = "" then ' where x is the variable to be checked whether
it has a value
'Hide the column
End If
On Mon, 17 Jan 2005 17:39:08 -0000, Cady <[EMAIL PROTECTED]> wrote:
>
> hi could anyone tell me how to use isNULL function..
> i have a sql database.. and got some NULL values on it..
> how do tell my script to skip something when there is a NULL value.
>
> i want to hide the whole coloumn when the script find some NULL
> values..
>
> need answer A.S.A.P, thank you gratefully if someone can help me..\
>
>
>
>
>
>
>
> ________________________________
> Yahoo! Groups Links
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
GJ Bondoc
15 V. Luciano St. Proj. 4 Q.C.
Tel#: 9118586 Cell#: 09274684926
e-mail: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
