Checking For Null

[KenM]

I've got a Listbox that is populated from a table rows in an Access database,
with the contents of the Listbox changin on user input into a textbox. One
field in each row is empty. I'm having a brain 'burp' getting the empty field
to 'not' be displayed in the dropdown.
The revelent code is below.
Any help getting my brain re-engaged will be appreciated.
Ken



<form method="POST" action="survey360_2006.asp" name="FrontPage_Form2">
<p>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="Name,LName,FName,Rate1,Rate2,Rate3,Rate4,Rate5,Rate6,Rate7,Rate8,Rate9,Rate10,Rate11"
s-columntypes="202,202,202,202,202,202,202,202,202,202,202,202,202,202"
s-dataconnection="360a" b-tableformat="FALSE" b-menuformat="TRUE"
s-menuchoice="Name" s-menuvalue="Rate2" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="360"
s-displaycolumns="Name,Rate1,Rate2,Rate3,Rate4,Rate5,Rate6,Rate7,Rate8,Rate9,Rate10,Rate11"
s-criteria="[Name] EQ {login} +" s-order s-sql="SELECT * FROM 360 WHERE (Name
= '::login::')" b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="login=" s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="0" botid="0"
u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0);
background-color: rgb(255,255,0)">Database</span> " startspan --><!--#include
file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM 360 WHERE (Name = '::login::')"
fp_sDefault="login="
fp_sNoRecords="No records returned."
fp_sDataConn="360a"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Name"
fp_sMenuValue="Rate2"
fp_iDisplayCols=12
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="59907" --><select
NAME="Rate2" SIZE="1">
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc"
startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot
bot="AspInclude" endspan i-checksum="52766" -->
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate1")%>"><%=FP_FieldHTML(fp_rs,"Rate1")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate2")%>"><%=FP_FieldHTML(fp_rs,"Rate2")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate3")%>"><%=FP_FieldHTML(fp_rs,"Rate3")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate4")%>"><%=FP_FieldHTML(fp_rs,"Rate4")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate5")%>"><%=FP_FieldHTML(fp_rs,"Rate5")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate6")%>"><%=FP_FieldHTML(fp_rs,"Rate6")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate7")%>"><%=FP_FieldHTML(fp_rs,"Rate7")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate8")%>"><%=FP_FieldHTML(fp_rs,"Rate8")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate9")%>"><%=FP_FieldHTML(fp_rs,"Rate9")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate10")%>"><%=FP_FieldHTML(fp_rs,"Rate10")%>
<option
VALUE="<%=FP_FieldHTML(fp_rs,"Rate11")%>"><%=FP_FieldHTML(fp_rs,"Rate11")%>
</option>

<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc"
startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" endspan i-checksum="52830" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " startspan --><!--webbot
bot="DatabaseRegionEnd" endspan --></nobr><input TYPE="submit" value="Proceed
To Survey"></p>

</form>