I get this error on line me.[Assign Fiche Clerk] = "NO DATA". This field is a text field on the table if that helps.
Code:
Private Sub Report_Load()
If IsNull(Me.INPUT_CLERK1) Then
Me.INPUT_CLERK1 = "NO DATA"
End If
If IsNull(RECEIPT_DATE) Then
Me.RECEIPT_DATE = "NO DATE"
End If
If IsNull(ASSIGN_PREP_CLERK) Then
Me.ASSIGN_PREP_CLERK = "NO DATA"
End If
If IsNull(PREP_ASSIGN_BEGIN_DATE) Then
Me.PREP_ASSIGN_BEGIN_DATE = "NO DATE"
End If
If IsNull([Assign Fiche Clerk]) Then
Me.[Assign Fiche Clerk] = "NO DATA"
End If
If IsNull(Fiche_Assign_Begin_Date) Then
Me.Fiche_Assign_Begin_Date = "NO DATE"
End If
If IsNull(INPUT_CLERK2) Then
Me.INPUT_CLERK2 = "NO DATA"
End If
If IsNull(BATCH_HEADER_DATE) Then
Me.BATCH_HEADER_DATE = "NO DATE"
End If
If IsNull(INPUT_CLERK3) Then
Me.INPUT_CLERK3 = "NO DATA"
End If
If IsNull(OUTPUT_START_DATE) Then
Me.OUTPUT_START_DATE = "NO DATE"
End If
End Sub