I have a record set that includes the field: Hunters_Comments. I have applied the Advanced Conditional Region to the text "Hunter's Comments:" so that the text will not show if the field is empty. Here is the code:

<% if rsLargeImage.Fields.Item("Hunters_Comments".Value<>"" then ' Adv Conditional Region %>
<font color="#3F1010" size="2" face="Verdana, helvetica, arial, sans-serifDefault Font"><strong>Hunter's
Comments:</strong></font>
<% end if ' rsLargeImage.Fields.Item("Hunters_Comments".Value<>"" %>
<br>
<font color="#3F1010" size="2" face="Verdana, Arial, Helvetica, sans-serif"><%=(rsLargeImage.Fields.Item("Hunters_Comments".Value)%></font>

The problem is that if the field is not empty, only the text "Hunters Comments:" shows up. The actual comments do not show up. If the field is empty, nothing shows up as expected.

Does anyone have any ideas?

Hi, it looks like your problem can be one of these things:

1 - the database field you are referencing is empty
2 - the SQL select string is not getting the contents of the row correctly or
3 - the field content is being pulled from the database ok, but is not displaying on the page because of some error in the rendered html

to really know which of these possible causes are more likely, we'd need to see more of the code including the SQL string if possible please.

Regards,

Myke Black

Edited by - mykeblack on 11 Nov 2005 17:34:48