This is the only one part of the code that does formatting.
Me.Controls("txtDateSprayed" & i).Value = Format(Me.Controls("txtDateSprayed" & i).Value, "mmm-dd-yy - HH:MM")
Me.Controls("txtReEntry" & i).Value = Format(Me.Controls("txtReEntry" & i).Value, "mmm-dd-yy - HH:MM")
Me.Controls("txtPHI" & i).Value = Format(Me.Controls("txtPHI" & i).Value, "mmm-dd-yy - HH:MM")
Try moving that up to the 'true' part of the If statement.
If Me.Controls("chk" & i) = True Then
Me.Controls("txtDateSprayed" & i).Value = Now()
Me.Controls("txtReEntry" & i).Value = DateAdd("H", txtMaxReEntry, Me.Controls("txtDateSprayed" & i).Value)
Me.Controls("txtPHI" & i).Value = DateAdd("H", txtMaxPHI, Me.Controls("txtDateSprayed" & i).Value)
'Format to dates and times
Me.Controls("txtDateSprayed" & i).Value = Format(Me.Controls("txtDateSprayed" & i).Value, "mmm-dd-yy - HH:MM")
Me.Controls("txtReEntry" & i).Value = Format(Me.Controls("txtReEntry" & i).Value, "mmm-dd-yy - HH:MM")
Me.Controls("txtPHI" & i).Value = Format(Me.Controls("txtPHI" & i).Value, "mmm-dd-yy - HH:MM")
Else
Me.Controls("txtDateSprayed" & i).Value = ""
Me.Controls("txtReEntry" & i).Value = ""
Me.Controls("txtPHI" & i).Value = ""
End If
Bookmarks