Access database memo field and printing

[chris5g]

I read out the data from the db and print it to the screen.
I use this code to do that for another Text field and it works.

do while NOT rs3.EOF
if rs3(&quot;Q7t&quot <> &quot;N/A&quot; then
response.write rs3(&quot;Q7t&quot
rs3.MoveNext
loop

For the Memo field, I had to save the dat to a temp variable then print it out. Like this...

do while NOT rs3.EOF
temper = rs3(&quot;Q8&quot
if temper <> &quot;No Response&quot; then
response.write temper
rs3.MoveNext
loop

Anyone know why this is so?

 

[warche]

Memo fields can be up to 2 GB, so the server only allows you to retreive the value once.

In your first set of code you referenced the Memo field twice. The first time it wasn't null but the second time it was.