Hi,
It's me again.
I need to add a line feed in a string and write to a field. It works if I use msgbox but not when I write to the field.
I have tried all the normal chr(10) and chr(13) and both together.
I have the following code:
If IsNull(Me.D1AM) Then
Me.D1AM = DLookup("[Given]", "Volunteers", "[ID] = " & Me.Combo14)
Else
Me.D1AM = Me.D1AM & Chr(10) & DLookup("[Given]", "Volunteers", "[ID] = " & Me.Combo14)
End If
aa = Me.D1AM + vbNewLine & DLookup("[Given]", "Volunteers", "[ID] = " & Me.Combo14)
Thanks
Peter
It's me again.
I need to add a line feed in a string and write to a field. It works if I use msgbox but not when I write to the field.
I have tried all the normal chr(10) and chr(13) and both together.
I have the following code:
If IsNull(Me.D1AM) Then
Me.D1AM = DLookup("[Given]", "Volunteers", "[ID] = " & Me.Combo14)
Else
Me.D1AM = Me.D1AM & Chr(10) & DLookup("[Given]", "Volunteers", "[ID] = " & Me.Combo14)
End If
aa = Me.D1AM + vbNewLine & DLookup("[Given]", "Volunteers", "[ID] = " & Me.Combo14)
Thanks
Peter