Check for NULL Values

by Linda Quinn

Close Window

Check all fields from a database.
If they have a NULL value, return the value as a SPACE.
If they are NOT NULL, return the value as a STRING.
The input parameter is a VARIANT, but the value returned is always a STRING.

Public Function StrNulls(vntField As Variant) As String

If IsNull(vntField) Then
StrNulls = " "
Else
StrNulls = Trim$(CStr(vntField)
End If

End Function

USAGE: txtAddress.Text = StrNulls(rs!Address)

=================================================================
This content was created by Linda Quinn of LQNet.

See http://www.lqnet.com for a great collection of articles on this and other topics.

=================================================================

====================================================================
Want an expert to help with your project? LQ Systems, Inc. Business Solutions
====================================================================

Check for NULL Values

Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.