-
I use ADO to get a recordset that is returned from SQL store procedure.
I can display all of the fields value in the
recordset but I got "Runtime Error" when I try to display the "TEXT" type field.
Here is the one line code that generates the error :
txtMemo.Text = rsep("EpisodeMemo")
in recordset all the text field is not empty.
Why this happen?
Thanks advanced.
-
Thanks. I just found out that I should set the recordset cursor type to "adOpenKeyset" not "adforwardonly".
-
What type of runtime error are you getting?
-
It is because of the reference that you are making. I think your code should be something like that.
txtMemo.text = rsep("EpisodeMemo").value
That will put the field value in the text propertie instead of trying to assign the field reference to a the text property of the box.
Good luck