"" or vbNullString

Question

While inspecting my VBA code, I found that I have "" and was recommended I have vbNullString instead.

Can someone tell me why I should have vbNullString and is it possible to change the "" to vbNullString as a batch?

Answer 1

It has to mainly do with memory.

Take a look at:

http://www.songhaysystem.com/kb/number/950165041/subject/vba
http://www.vbforums.com/showthread.php?351311-Why-use-vbNullString
http://www.utteraccess.com/forum/lofiversion/index.php/t1994779.html

An someone's analysis/testing http://www.jpsoftwaretech.com/len-vs-blank-strings-vs-vbnullstring/

---

Daniel Pineault, 2010 Microsoft MVP
http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net