Prestwood IT: Access VBA Empty String Check (Len(s&vbNullString)) (Microsoft Access)

Access

	Access Group Home
Get Started Page eMag: Access Edition Highlights WEEKLYLESSON Week 10 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	Access KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles Access News Resource Links ACCESSTIDBITS: All as FlashCards Code Snippets FAQs Tips

	Access To/From
To/FromCODEGuides Access To/From

	Access Study Test
PRESTWOODCERTIFIED Access Study Test

	Access Store
PRESTWOODSTORE Store Home Buy Access Items

	Members Only
MEMBERSONLY Access Member List Member Only KB Posts Access Content Stats Random Article Random MB Thread Random Tidbit Random CrossRef Code

Prestwood eMagazine

March Edition

Subscribe now! It's Free!

► KB ► Desktop Data... ► Access & VBA

Print This

From the August 2015 Issue of Prestwood eMag

Access & VBA:

Access VBA Empty String Check (Len(s&vbNullString))

By Mike Prestwood

Posted 16 years ago on 9/17/2009

Access Code Snippet:

To/From Code Guide: Access VBA Empty Str... vs. Other Languages

A flashcard from our Access Flashcards Library

A code snippet from our Access Code Snippets Page

Tags: Access VBA , Empty String Check

KB102038

Languages Focus: Empty String Check

An empty string is a zero length string, a string that is equal to null (""), or not assigned. In some languages, you can check if a string is empty by comparing it to an empty string (""). Some languages distinguish between nil and null ("") so checking if the length is 0 is easier.

Access VBA Empty String Check

In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Syntax Example:

All these will work for variables unassigned, set to "", or set to Null:

If s&"" = "" Then
  MsgBox ("Quotes with &'' say null is empty")
End If

 
If Len(s&"") = 0 Then
  MsgBox ("Len with &'' says null is empty")
End If

If Len(s&vbNullString) = 0 Then
  MsgBox ("Using vbNullString also works!")
End If


Comments 1 Comments. Share a thought or comment...

PS_4523

Comment 1 of 1

I do believe this is an excellent website. I stumbled upon it I may revisit once again since I saved as a favorite it. https://www.marylandhealth-connection.com

Posted 91 hours ago

Code Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

KB Article #102038 Counter

20386

Since 9/17/2009

Prestwood eMagazine

KB102038

Languages Focus: Empty String Check

Access VBA Empty String Check

Comments