I have known people writing apps in MS-Office like Access, Word, or Excel using VBA, and I was assigned to convert it to VB 6.0 and SQL Server. Usually the ove

I have known people writing apps in MS-Office like Access, Word, or Excel using VBA, and I was assigned to convert it to VB 6.0 and SQL Server. Usually the over the weekend projects need debugging and error trapping and other things to it. I can't tell you how many Invalid Use of Null errors where avoided by using the trim function and adding a blank quote "" next to the variable that held data: result = trim("" & RS(index)) Just a simple modification that new programmers didn't know.