FYI,
the colon ":" is a line continuation token left over from the BASIC language. (back in the ancestral time of computers - the IBM XT )
It is still in VB/VBA for backward compatibility, but it has been depreciated.
This code
Code:
Private Sub txtQtyOfBackOrderReceived_AfterUpdate()
If IsNull(Me.BackOrderReceived) Then
[txtBackOrderReceived] = [txtQtyOfBackOrderReceived]
Else '<<-- notice no colon
Me.txtBackOrderReceived = [txtQtyOfBackOrderReceived] + [txtBackOrderReceived]
End If
End Sub
will still execute if written like
Code:
If IsNull(Me.BackOrderReceived) Then:[txtBackOrderReceived] = [txtQtyOfBackOrderReceived]:Else:Me.txtBackOrderReceived = [txtQtyOfBackOrderReceived] + [txtBackOrderReceived]:End If
BUT it is sooooo much harder to read.
The point being, it doesn't hurt anything, but you don't/shouldn't use it. Never know when MS will remove it from VB/VBA.