Null and ""

Hi:

I have a question
In VB Code:

case 1: I set one variable to be Null
value1 = Null

OR

case 2: I set one variable to be ""
value1 = ""

What is the difference?
Is the "" still count one character??? "" => 1 character
Null is meaning nothing, empty, right.
If (isnull(value1)) then
...
end if

From above code, case1 will be worked, right.

Please let me know, thanks.

Thanks.

You are quite right. Databases draw a distinction between NULL which means no value, and an empty string which is an empty string.

In Access you have to AllowZeroLength strings on text fields.

Similarly in VB/VBA variant variables can hold a NULL value.