how do i...

[1jet]

assign null to a string value?

 

[boblarson]

I don't believe you can do that. The best you can do is make it an empty string:

strMyString = ""

 

[DJkarl]

assign null to a string value?

You can't in VBA. Best you could do make it a zero length string.

yourString = ""

or

yourString = Empty

Now if you are referring to a "Null terminated" string that some API's require then just add a Chr$(0) to the end of your string.