Access 97

A

Alan

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?
 
A

Allen Browne

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
 
Top