Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access database memo field and printing

Status
Not open for further replies.

chris5g

Programmer
Aug 21, 2001
48
US
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top