I remember something from college about there being some special null value that you have to use when writing to an Access database. Right now a bunch of text fields in the DB are Allow Zero Length: No. So when I try and send it this statement:

INSERT INTO [DOG DATA] ([OWNER ID],BREED,SEX,[SEX ENTRY],[CALL NAME],[DATE OF BIRTH],[PLACE OF BIRTH],BREEDER,SIRE,DAM, [DOG HEIGHT],[NADAC REG NUM],[NADAC DOG HEIGHT],[NADAC MEASURED JUMP HEIGHT]) VALUES (379,'border collie','Female','2','Taka','02/14/2001','','','','',21,'07-04215',21,'16')

it gives me an error about the value of those red ones being a zero length string. I'm using string variables to build the SQL statement's values right now. Is there some value I can assign them that it will accept like "NULL" or something? I recall using something like VBNULL or DBNULL or something a long time ago but nothing I've tried worked so far.