Ok here is one I have been fighting with for a few days. I have a VB6
front end that ties into a MS Access 2000 database. The front end has
many textboxes some of which will not be used buy every user. These
textboxes are bound to the database and work fine except in one case..
if the user enters data in the textbox and then decides to remove it (
ie. just backspace and leave it blank ), Access will not except it
when I try to update that field. The first issue is that the Access
database must be set to not allow a zero length field ( decision made
above my head ) otherwise it would go in with no problems. The second
is that the powers that be do not want to use a blank space entered
into the field to achieve a non zero length field. So the the big
question is how to I add a NULL that Access will accept? I dont think
VB NULLs are quite the same in the translation. Any help would be
great..... Thanks..

e.g.
    rs.Fields("Some Field").Value = _
        IIf(txtSource = "", Null, txtSource)