1. Home
  2. Computing & Technology
  3. Databases

Microsoft Access Function Library: IsEmpty()

By Mike Chapple, About.com

Function: IsEmpty()

Purpose: The IsEmpty function returns a value of true if the referenced variable has not been initialized. Otherwise, it returns false.

Usage: IsEmpty(variable_name)

Where variable_name is the name of the variable you wish to test.

Returns: True if the referenced variable has not been initialized; False otherwise.

Example
Dim TestEmpty
TestArray = Array(1,2,3)
TestInt = Int(1)
TestDate = "June 10, 2000"
IsEmpty(TestEmpty) returns True
IsEmpty(TestArray) returns False
IsEmpty(TestInt) returns False
IsEmpty(TestDate) returns False
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Access Function Library
  6. Microsoft Access Function Library: IsEmpty()>

©2009 About.com, a part of The New York Times Company.

All rights reserved.