I can't remember what the code is to ignore nulls when filling a textbox. How can I make this statement ignore them?
txtLocation = rst!Location
smh
(It must be getting near the end of the day!)
Printable View
I can't remember what the code is to ignore nulls when filling a textbox. How can I make this statement ignore them?
txtLocation = rst!Location
smh
(It must be getting near the end of the day!)
If Not IsNull(rst!Location) Then
txtLocation = rst!Location
End If
Alternatively:
txtNumber.Text = RS!Location & ""
- gaffa