display null field from recordset to textbox

[jackiev]

I know the LONG answer to this question...
Is there a short answer that I am overlooking?
Pulling a recordset from an Access database &
displaying the fields to an array of textboxes using
simple code:
while not rs.eof
textbox1(index) = rs.fields("fieldname1&quot.value
textbox2(index) = rs.fields("fieldname2&quot.value
... there are 20 textboxes to fill
index = index +1
wend

Problem: if any rs.field.value is null, error occurs.
LONG ANSWER:
while not rs.eof
if isnull(rs.fields("fieldname1&quot.value) then
textbox1(index) = " "
else
textbox1(index) = rs.fields("fieldname1&quot.value
endif
**repeat this for all 20 textboxes
index = index + 1
wend

WHAT AM I MISSING PLEASE?

 

[dpaulson]

How about

textbox1(index) = rs.fields("fieldname1&quot.value & ""
David Paulson

 

[jackiev]

That does it. Thanks a bunch.

 

[yauncin]

There is a function that basically does that:

textbox1(index) = Nz(rs("fieldname1&quot, "&quot

This should work.