Conditional Formatting Table Value...


1

116

I have been attempting to change how a column is displayed based on another
columns value.
If FP_FieldVal(fp_rs,"HolDate") > Date() THEN...I would like for the other
column to display as BOLD.

Thanks for any assist,
David
 
Ad

Advertisements

S

Stefan B Rusynko

Put that code in the other table cell that you want bold wrapping the other field ( say named: otherfield)
<td>
<% If FP_FieldVal(fp_rs,"HolDate") > Date() Then %><b><% End if %>
<% =FP_FieldVal(fp_rs,"otherfieldname") %>
<% If FP_FieldVal(fp_rs,"HolDate") > Date() Then %></b><% End if %>
</td>




I have been attempting to change how a column is displayed based on another
columns value.
If FP_FieldVal(fp_rs,"HolDate") > Date() THEN...I would like for the other
column to display as BOLD.

Thanks for any assist,
David
 
1

116

Hello Stefan, below are the columns in question and how I understood. Not
sure if placed properly, but either ALL is bold or not, depending on the < or
. Seems as if Date() is not seeing HolDate as a date?
<td style="text-align: center" width="20%" height="32"><font size="2">
<% If FP_FieldVal(fp_rs,"HolDate") < Date() Then %><b><% End if %>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="EntryID,HolYear,Holiday,HolDate,HolDay,HolPaid,HolCmnts"
s-column="Holiday" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Holiday<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Holiday")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="13897" -->
<% If FP_FieldVal(fp_rs,"HolDate") < Date() Then %></b><% End if %>
</font></td>
<td style="text-align: center" width="16%" height="32"><font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="EntryID,HolYear,Holiday,HolDate,HolDay,HolPaid,HolCmnts"
s-column="HolDate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>HolDate<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"HolDate")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="13643" --></font></td>

David
 
Ad

Advertisements

J

Jon Spivey

Try casting the field value as a date
<% If cdate(FP_FieldVal(fp_rs,"HolDate")) < Date()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top