Writing Empty text fields to a table

[JulieS]

Hi,
My form (that i created in InterDev) gives me an error when I try to submit text fields that have no data in them (and no, these are not required fields in my database).
Is there any way to initialize these textboxes? I've tried everything:
Dim MyVar As Variant
MyVar=Null
MyVar=""
etc, but nothing seems to work.
Any ideas?

Thanks!!!!!!!
Julie