PC Review


Reply
 
 
=?Utf-8?B?QWxhbg==?=
Guest
Posts: n/a
 
      7th Nov 2007
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?
 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      7th Nov 2007
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?


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't open my Access files after conversion from Access 97 to Access 2003 M Shafaat Microsoft Access 5 10th Apr 2010 09:04 PM
Saving Access 2007 database in Access 2003 format fails in Access =?Utf-8?B?U3Bpcm8=?= Microsoft Access External Data 0 13th Aug 2006 08:37 AM
W2K3 Service w/ UNC Access, Local Disk Access, and DB Access Rob Microsoft C# .NET 6 2nd Aug 2004 01:44 PM
Access "showing images on first page only of very wide Access report. Windows XP, Access XP Jack Microsoft Access Reports 4 18th Nov 2003 03:01 PM
Re: Allowing users (w/o MS Access) to access an Access 2000 database Wayne Morgan Microsoft Access 0 29th Sep 2003 11:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:02 PM.