jeran042
Registered User.
- Local time
- Yesterday, 18:55
- Joined
- Jun 26, 2017
- Messages
- 127
Good morning,
I am trying to replace line breaks (carriage returns) from within a form control. Here is what I am currently trying without luck:
The DLookUp result is correct, but the Replace functions do not remove the line breaks (or what I know are carriage returns)
Any suggestions?
Much appreciated,
I am trying to replace line breaks (carriage returns) from within a form control. Here is what I am currently trying without luck:
Code:
=Nz(DLookUp(Replace(Replace("NOTES",Chr(13)," "),Chr(10)," "),"tblInvoiceLog","[VOUCHER_NUMBER]= " & [txtTEST] & ""),"")
The DLookUp result is correct, but the Replace functions do not remove the line breaks (or what I know are carriage returns)
Any suggestions?
Much appreciated,