memo field losing value

[raj chahal]

hi there

I'm displaying the contents of a mem field in access. Whenever I access this
field, the field loses the value on the 2nd attempt.

response.Write "Pro1 " & (Recordset1.Fields.Item("profile1").Value)
response.Write "Pro1 " & (Recordset1.Fields.Item("profile1").Value)

if I execute the above in asp I only manage to print the value of
'Recordset1.Fields.Item("profile1").Value' once.

Someone said it's to do with the fact I'm using a memo field..Any
explanations and workarounds pls.

thanks

 

[TC]

What happens on the second line? Do you get an error? If so, what is
it? If not, what happens instead?

TC (MVP Access)
http://tc2.atspace.com

 

[raj chahal]

when the 2nd line is executed nothing is prined to screen and no error
messages