Wrap the field in some script that checks to see if it's empty; here's an
example:
<% If fp_rs("Municipality") > " " then %>
<li><b>Municipality:</b> Â<!--webbot bot="DatabaseResultColumn"
startspan
s-columnnames="ProgramArea,RecÂordNum,Date,ItemNumber,SplitItÂem,Session,PAÂ_SA
,ActNumber,Section,Recipient,MÂunicipality,FundsUse,DollarFieÂld1,DollarFieÂld2
,DollarField3,DollarField4,AnyÂ_Previous,DollarField5,FundNumÂ,AgencyNum,SIÂD,P
roject_Num,Description"
s-column="Municipality" b-tableformat="FALSE" b-hashtml="FALSE"
clientside
preview="<font
size="-1"><Â;<</font>MunicipaÂlity<font
size="-1">>Â;></font>" b-makelink
b-MenuFormat --><%=FP_FieldVal(fp_rs,"MunicÂipality")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="33247" --></li>
<% End If %>
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
Trillian said:
I only want to suppress the blank field and its "line", not the entire
record.
Stefan B Rusynko said:
Set the criteria of the DBRW to not include empty records (<>"" or not
null depending on your data structure)
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
|A field in my DRW section may not contain a value for some records. Is
there
| a way to suppress the resulting blank line so the field under it will
"move
| up"?