Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove line if blank in a label
Message
From
29/03/2006 13:03:03
 
 
To
29/03/2006 12:36:30
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01108475
Message ID:
01108897
Views:
14
>I will show you a great, well hidden, trick which has been there since Foxpro DOS.
>
>On the label you create a field which is big enough to show what you want, like a box. Enter all the information you want to show in the Expression box, like this:
>firstname,lastname;address1;address2;shortstate,zipcode;country.
>All the fields which are separated by a komma, will be properly formatted with one space between the trimmed values. If the first value is blank, the second value will come first.
>All fields which are separated with a semikolon, will come on a new lines, and blank lines will be skipped so that the next value is shifted up.

Goes all the way back to dBase ][.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform