Bookmarks and Null values

[Topham]

Hello Guys,

I have a section of my form that may contain no data what so ever and therefore i need to have a code that if theres no data a field to put a space and if there is a value to put the value in.

Heres the code im using and yet im getting Error 94 Invalid use of null

If [MEBondingConLocation1] = Null Then
.ActiveDocument.Bookmarks("Text37").Select
.Selection.Text = " "
Else
.ActiveDocument.Bookmarks("Text37").Select
.Selection.Text = Me.M_EBondingConLocation1
End If

Any advice would be great.
Topham

 

[pbaldy]

Try

If IsNull([MEBondingConLocation1]) Then

or to test for both Null and a ZLS

If Len([MEBondingConLocation1] & vbNullString) = 0 Then