The first picture shows the characteristics of the text boxes I have so far.
The second picture is when I go to Form View
Here is the code that is being called:
Function MissingInfo(ID As Integer)
Dim str As String
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Inspections WHERE ID = " & ID)
If IsNull(rs!MHType) Then
str = str + "Type "
End If
If IsNull(rs![Elevation (45)]) Then
str = str + "Elev "
End If
txtMissing = str
Set rs = Nothing
End Function