Null Value Retreival

C

Carolyn

We are using foms to gather data. Indiviudals are accessing an online form
and inputing data using memo and text boxes, as well as check and radio.

I have no problem with my queries unless the memo or text box is empty of
content...blank...isn't the value then NULL? I get neither content or an
error from this query, and from all like queries. I tried "0" and null
without the quotes.

<% if "null" = FP_Field(fp_rs,"SXIActiveTrialSummaryStudyDesign") then
%>Information is not available.<%end if%>

It is my intention to, 1) display the content of the memo, OR 2) display
"information is not available" if the memo box is left blank/empty.
 
B

Bob Lehmann

<%
If Not FP_Field(fp_rs,"SXIActiveTrialSummaryStudyDesign") = "" Then
'Display the field
Else
'Information is not available
End If
%>

Bob Lehmann
 
Top