Okay, I've been out of the VB6 loop for a while and remembered having an issue with this a while back, in which I cant remember the solution.

I have a VB form that is connecting to the database and retrieves information (obviously ;p). The issue that I'm having is retrieving the information within a memo field from a MS Access database.

My connection and recordset code is correct and I have retrieved info just before the call, but when it comes to the memo field, I'm constantly getting "null" run-time errors.

MstrSQL = "select js_file_code from js_file where identifier='" & replace(cmbIdentifiers.text),"'","''") & "'"
MobjRS.open MstrSQL, MobjCN
   if isnull(MobjRS.fields("js_file_code")) then
     MstrFile = ""
   else
     MstrFile = MobjRS.fields("js_file_colde")
   end if
MobjRS.close
...

Funny issue here, is that on the line of "if isnull" it passes that error check which is true in the database... but when I try to assign the value to a variable, it gives me a null error...

This is frustrating me lol, so any help will do.

Thanks in advance!
Rolandatem

oh, I forgot to add, that if I tell the code to post the sql query to my screen. I can copy it and paste it as a query in ms access, and it works perfectly.

  well you say nothing is wrong with the code! why not check the property of the js_file_code field tell it to return a zero value if null.

Arowolo