Both the clinic no and Address2 are null in the database:
This is how they are retrieved:
patreg.ClinicNo = IIf(IsDBNull(xdr("CLINIC_NO")), "", xdr("CLINIC_NO"))
patreg.Address2 = IIf(IsDBNull(xdr("ADDRESS2")), "", xdr("ADDRESS2"))
Then their values are assigned to textboxes on a web form:
For the Clinic_No, nothing is displayed in the textbox, which is correct.
However, for Address2, the html code for a non-breaking space is
displayed inside the text box!
What could I be doing wrong?