So you want to replace all commas with a Carriage Return and Line Feed?
In more recent versions, you could use a text box with Control Source of:
=Replace([Address], ",", Chr(13) & Chr(10))
Access 97 doesn't have a Replace() function, but you can copy the one
towards the end of this page:
http://allenbrowne.com/AppFindAsUTypeCode.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Alan" <(E-Mail Removed)> wrote in message
news:93789EED-CFE8-4328-A295-(E-Mail Removed)...
>I have all my address data in one field seperated by commas. I need to
>print
> the adress data in a label form within a word document across three lines.
> How do i do this?