Null Values

[technohead]

Hi,
i am taking values from the database and want to validate it so that if there is no value in the database corresponding to the field then the textbox on the form will just be zero.
this is the way i am using it, but brings up an item not found error for some fields.

is this way suitable or is there a better way of doing it




If IsNull(rs1!SqYardsUsed) Then
frmOrdersandSales.txtordSqyardsUsed.Text = ""
Else
frmOrdersandSales.txtordSqyardsUsed.Text= rs1SqYardsUsed
End If


thanks

 

[dsb]

no need for IsNull()

frmOrdersandSales.txtordSqyardsUsed.Text = "" & _
= rs1SqYardsUsed

 

[technohead]

Is this exactly how it should be entered?? it just comes up as red text. do i not need an if statement or anything

 

[mmilan]

Drop the second equals character...


Martin

 

[dsb]

how did that = get in there? ..thanks =mmilan