For what its worth I mocked up a couple of addresses. I entered the data directly into the table (tblMockAddresses) and used Ctrl Enter to enter CrLf's.
The data is shown in the graphic along with the 2-up labels I created using the Label wizard directly on the table.
To ensure the input data actually contained CrLF Chr(13) Chr(10), I used this routine
Code:
Sub testdec12()
Dim x As Variant, i As Integer
Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("tblMockAddresses")
Do While Not rs.EOF
x = Split(rs!ADDRLINE, Chr(13) & Chr(10))
For i = LBound(x) To UBound(x)
Debug.Print rs!id; i; x(i)
Next i
rs.MoveNext
Loop
End Sub
and got this output
Code:
1 0 27 Smith St.
1 1 Kingston, Ontario
1 2 CANADA
2 0 2200 Lake Clark Drive
2 1 Lake Worth
2 2 Florida, USA, 33461
Since this data is meant to represent the OP's data, and since it works for me, I think there must be something the OP hasn't told us, or isn't aware of.