The problem is because your records contain null values, they cannot directly be assigned to textboxes and other controls. I guess you are using a data control and bound controls.

In that case I don't know the solution to your problem, except that you can make all the fields in your database compulsory, i.e. Required = Yes and AllowZeroLength = No, or else you can provide default values to those fields which you think will remain null.

In code I have got this trick to work around the nulls:

Code:
Text1.Text = rs.Fields("FirstName") & ""
This ensures that the null values in the database don't crop up in your forms.