mattbutler

I was tearing my hair out with this then finally realised what the problem was. When I execute a command and set the datasource of a hierachialflaxgrid to the executed command, the grid shows all the fields but once it comes across a field that is of the memo type that field and any fields there after show as blank values.

I set a recordset to the executed command and then I am able to view the values for fields of Memo type but once again if I set that recordset as the datasource of the grid, from the first field that is of the memo type and any fields thereafter show as blank values in the grid.

Why is this and is there anyway around this because I dont really want to code around it as the simplicity of setting the datasource to the executed command is perfect for want I want and unfourtunatley I cannot change the field types in the table as I need text fields that can hold values greater than 255 characters.

Im sure someone can give me a good solution so any thoughts would be greatly appreciated.

Thanks