Well not really but......

I have an insert statement that looks mostly like this.....

Code:
mySQL = "INSERT INTO myTABLE (someDumbDate) VALUES (#" & aTextBox.text & "#)"
This works fine when aTextBox.text has a real date in it but is causing me unspeakable grief when aTextBox.text = "".

Is there an easy way around this?

Database: MS Access 2003
Language: Visual Basic (VS 2005)