Link to home
Start Free TrialLog in
Avatar of thatelvis
thatelvis

asked on

if else including null and empty record

Hello,

I have an if else statement which works if the record is empty but has a had a record in it before, how can I have this so it can also check for null, as in if spud = "" or null.

 <%
' Show IF Conditional region14
  If (Recmostofuser.Fields.Item("spud").Value) = "" Then
%>

grateful for any help

regards


Kenny
Avatar of Carl Tawn
Carl Tawn
Flag of United Kingdom of Great Britain and Northern Ireland image

Try:

    If IsNull(Recmostofuser.Fileds.Item("spud").Value) Or Recmostofuser.Fields.Item("spud").Value) = "" Then
ASKER CERTIFIED SOLUTION
Avatar of DireOrbAnt
DireOrbAnt

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of thatelvis
thatelvis

ASKER

this worked thanks all

If ("" & Recmostofuser.Fields.Item("spud").Value) = "" Then


kenny