Format line with , in memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have postal adresses that the input is as follow :
PO Box 770, Durban, 9000

Is there a way to change the format, to
PO Box 770
Durban
9000

I want an (Enter Space) after the ,

Thanks
 
Hi Heilbron,

yes, you can use REPLACE
replace("PO Box 770, Durban, 9000",", ",vbcrlf) -->
PO Box 770
Durban
9000

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Back
Top