To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Corel Paradox Delphi Delphi Prism Java JavaScript Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics +OOP Details

	Perl Guides
Perl To/From Conversion Guides Perl and ASP Classic Perl and C# Perl and C++ Perl and C++/CLI Perl and Corel Paradox Perl and Delphi Perl and Delphi Prism Perl and Java Perl and JavaScript Perl and PHP Perl and VB Classic Perl and VB.Net

Cross Ref Guide

PERLLANGUAGE

Perl

PERLANDACCESS VBATOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

Empty String Check◄╣

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► Perl

Print This

Empty String Check (Perl and Access VBA Cross Reference Guide)

By Mike Prestwood

Perl versus Access VBA: A side by side comparison between Perl and Access VBA.

Operators

A language symbol used for assignment, comparison, computational, or as a logical.

Empty String Check

[Other Languages]

Languages Focus

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.

[Not specified yet. Coming...]

Access VBA: Len(s&vbNullString)

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