vba macro?

[sam111]

For my job I was handed a project that uses word vba macros to create a microsoft word report document.

I needed away if the database has a non null arc_model field to set the variable of mstrModel to that. However when I debug it always gets set to the engine_model field.

Does anybody see anything wrong with the below code for this logic

If IsNull(rs.Fields("ARC_MODEL").value) = True Then
mstrModel = rs.Fields("Engine_Model").value
Else
mstrModel = rs.Fields("ARC_MODEL").value
End If

Thanks for any help

[macropod]

Hi sam111,

Perhaps:
If Trim(rs.Fields("ARC_MODEL").value) = "" Then