Hey there,
I'm a noob and here is my issue. I'm importing from excel, the fields either say TRUE OR FALSE once entered, Access for some reason converts to 0 and -1, I just want the 0 to say N and if it says anything other in both of these fields shown below to enter a Y...Here is the code I am trying. Also, I only know how to enter the code to run on a form and didn't know if I could have it run it after the table is imported rather than go through each record. Thanks to everyone for any help!
Private Sub Form_Load()
If Me.Leak_Found = 0 Then Me.Leak_Found = "N"
Else
Me.Leak_Found = "Y"
End If
If Me.Atmospheric_Corrosion_Found = 0 Then Me.Atmospheric_Corrosion_Found = "N"
Else
Me.Atmospheric_Corrosion_Found = "Y"
End If
End Sub