invalid use of null

[pds8475]

Hi
On my database I'm getting a invalid use of null error when I click save if I leave the notes empty. From what I have read a string can't be Null. So you use Nz. But how do you structure the statement when defining your string variable?
I have included a cut down copy of my database.

Any help would be much appreciated.

 

[pds8475]

Doesn't matter I have figured it out. Since a string can't be null. You need To declare it as a variant. ie Dim Note As Variant

 

[jdraw]

If the field is a string, you might use NZ(yourfield,"") to make it a zero length string rather than NULL.