* 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
USAGE: txtAddress.Text = StrNulls(rs!Address)
Copyright © 2006-2016, LQSystems,Inc. All rights reserved.
If IsNull(vntField) Then
StrNulls = " "
StrNulls = Trim$(CStr(vntField)