Basically I have a checkbox in my Access database and I want to display a TICK on my details page if the value in the database is TRUE, if it is FALSE then I want to display a CROSS.

Sounds simple but just can't work out how to do it, anyone have any idea's. I am using MX so an extension would be fine but handdonding would be ok to, just need it done. Thanks

<pre id=code><font face=courier size=2 id=code>
&lt;img src="&lt;% if ((rs.Fields.Item("field".Value) &lt;&gt; "FALSE" then %&gt;TICK&lt;%Else%&gt;CROSS&lt;%End If%&gt;"&gt;
</font id=code></pre id=code>

I've put the code in but still seem to be having problems as although the value in the database is 0 (false) the tick image still appears.

I have put my DB info in changed false to 0 and then replaced the words TICK and CROSS with the full url of the pictures. I tried pasting it in but it won't display properly even when I select code. You can email me if you want to see the code (m.howell@@lineone.net)


Can you spot what I've done wrong?

Thanks

<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Then reverse it and look for true..

<pre id=code><font face=courier size=2 id=code>
&lt;img src="&lt;% if ((rs.Fields.Item("FieldName".Value) = True) then %&gt;pix/tick.gif&lt;%Else%&gt;pix/cross.gif&lt;%End If%&gt;"&gt;
</font id=code></pre id=code>
If that doesn't work...

Try just displaying the field value instead of displaying the picture...

<pre id=code><font face=courier size=2 id=code> &lt;%=(rs.Fields.Item("FieldName".Value)%&gt;</font id=code></pre id=code>

... and see what values the browser is seeing. Then test for them (If "1" Else - or - If "Yes" Else, etc...)

i use this code myself and it does work.

<pre id=code><font face=courier size=2 id=code>
&lt;% IF rsRecordset.Fields.Item("YourField" = "True" THEN %&gt;
&lt;img src="GreenTick.gif" width "12" height="12" border="0" alt="Yes"&gt;
&lt;% ELSE %&gt;
&lt;img src="RedCross.gif" width "12" height="12" border="0" alt="No"&gt;
&lt;% END IF %&gt;
</font id=code></pre id=code>

just replace <b>rsRecordset.Fields.Item("YourField" </b> with what your rs code is
and swap gif names for GreenTick and RedCross.

Regards,
Dave

UD4 | Flash 5/MX | Studio MX | SQL | Access | ASP/VBScript | XP-Pro

Excellent, works a treat

Thanks for that guys
<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>