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

Good Luck,
Dean Thompson

I figured this out, but is there a way to get the
"Allow Zero Length" automatically set to "True" in Access?

Thanks for any help,
-Steve

: 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

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

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