
Null Values - WHY am I getting this error?
I figured out about the "Allow Zero Length" boolean flag after my
original post. But what I still couldn't figure out is how to
make the "allow Zero Length" flag to be True by default. Or the
VB code to change the boolean flag to True.
The program I'm developing is creating a table and is then inserting
in values depending on the user input. The input may be nothing.
At no time is anyone going to go into Access and change the "Allow Zero
Length Values". So I'm at a stop sign right now.
Thanks for any help,
-Steve
: Does anyone have VB code that will go through a table
: and change all the "Allow Zero Length" flags for all
: text values to "True".
: Or does anybody know how to change the flag to True
: by default?
: Thanks for any help,
: -Steven Job
: : The following code:
: : txtaddress.Text = strAddress
: : mrs![Address] = strAddress
: : This is with an Access database. I knew that Visual Basic variables
: : (excluding variants of course) couldn't handle a null value, but I
: : thought Access could. I thought MOST databases could... Is there a
: : different DAO reference I could use?
: : Or do I have to do:
: : If Not IsNull(strAddress) Then
: : mrs![Address] = strAddress
: : End If
: : That would be a pain to do it with every single value.
: : Thanks for any help,
: : -Steve Job