When I bind Objective Grid to a SQL server database with a text field all the other fields show up as expected but the text field shows up without any data.

When you use Class Wizard to generate a CRecordset derived recordset to bind to a SQL server database with a text field, CW maps the text field to a CString member and also a RFX_Text data  exchange function. This does not work as expected. The fix is to modify the recordset declaration from CString to CLongBinary and RFX_LongBinary. The data will then show up.

This happens only with ClassWizard generated recordsets and will not happen if you use CGXDynamicRecordset.