ADO/Datagrid cell value after edit

I am using a datagrid which is populated with the results of an ADO generated recordset, that allows the user to edit some fields.

What I want to do, is after the user has edited the contents of a cell and moves off this cell, check to see what the cell contents are to remove any trailing blanks. I've tried looking at the AfterColEdit event and BeforeColEdit/Upate events, but they only seem to show the old value, and not the new.

I haven't loaded any of the VB service packs, so could this affect things? I've got SP3 ready to load, been told to avoid SP4 because of possible knock on problems with SQL server 7 (upates MDAC to 2.5?) so steered clear of this so far.

I tried trimming the data in the select part of the recordset but this stops changes to the data being sent back to the database.

Thanks for any ideas.