Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blank address lines
Message
 
To
10/11/2004 03:26:42
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00959791
Message ID:
00959963
Views:
17
Tore .. you beat me to it!! I use this trick all the time and I have found that very few people know about it. Usually when I show this trick in a session at a conference somone will ask if this is new to version [the latest]. When I tell them this has been around since Dos -- everyone is in shock!!

Cathy


>Did you know that you can simplify this with an old trick which is not commonly known, but which has been around since DOS days? Enter ONE line like this:
>m.company
>M.addr1;M.addr2;M.addr3;m.addr4;city,state,' '+zip
>I'm sure you won't believe me, but this one line will do ALL the things you want! The semicolon means 'print the next word on a new line if it's not empty', the komma means 'trim the next words and separate them on one line with a space between them.
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform