Hi all, please help!

I basically want to replace a null value with the text N/A, and I'm buggered if I can figure it out!! I was thinking along the lines of :

If rsReordsetName.Fields.Item("FieldName".Value IsNull Then
Response.Write("N/A"
End If

Any help would be great!!

PS using ASP and Access 2000, field is of the numeric variety

Tar

If you are looking to insert a default value into the DB from an insert page, look of the line of code that looks something like this
<pre id=code><font face=courier size=2 id=code> MM_columnsStr = "section|',none,''|title|',none,''|teaser|',none,''|thumb|',none,'noimage.gif'|body|',none,''"</font id=code></pre id=code>

obviously yours will be different.

Put what you want entered into the DB in between the ' '. You will seen on my example I have put noimage.gif in.

Hope this makes sense and is what you aree after

Regards
Wayne