LABELS PDOX 4.02 DOS 
Author Message
 LABELS PDOX 4.02 DOS

Is there any way to set up labels from a table that contains
names with middle Initials and without middle initials that
will print uniformly?

If I place the MI field in label with spaces before & after
the label prints OK where name contains MI, but has too much space
on the names without middle initials.  

Field Squeeze doesn't help as it only works on Fields... but won't
squeeze a line with an empty field.

Would appreciate any help.

Bstuttman



Mon, 06 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Quote:

>Is there any way to set up labels from a table that contains
>names with middle Initials and without middle initials that
>will print uniformly?

>If I place the MI field in label with spaces before & after
>the label prints OK where name contains MI, but has too much space
>on the names without middle initials.  

>Field Squeeze doesn't help as it only works on Fields... but won't
>squeeze a line with an empty field.

>Would appreciate any help.

>Bstuttman

Use a calculated field along the lines of :

IIF([Initials]=""," "," "+[Initials]+" ")

--
Marilyn Ainslie
Cheshire  UK
http://www.cloud9.u-net.com/



Mon, 06 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Use a calculated field such as:
[first name]+" "+iif(isblank([mi]),"",[mi]+". ")+[last name]
be sure to include enough space to accomdate the combined length of all
fields, Use the concept for the addresses city state and zip too.

ps:     the iif is intentional



Quote:
> Is there any way to set up labels from a table that contains
> names with middle Initials and without middle initials that
> will print uniformly?

> If I place the MI field in label with spaces before & after
> the label prints OK where name contains MI, but has too much space
> on the names without middle initials.  

> Field Squeeze doesn't help as it only works on Fields... but won't
> squeeze a line with an empty field.

> Would appreciate any help.

> Bstuttman



Tue, 07 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Do a calculated field  

iif([MI]<>"",[fname]+" "+[MI]+" "+[lname],[fname}+" "+[lname])

where [MI] is the initial variable and fname and lname are obvious

Quote:

>Is there any way to set up labels from a table that contains
>names with middle Initials and without middle initials that
>will print uniformly?

>If I place the MI field in label with spaces before & after
>the label prints OK where name contains MI, but has too much space
>on the names without middle initials.  

>Field Squeeze doesn't help as it only works on Fields... but won't
>squeeze a line with an empty field.

>Would appreciate any help.

>Bstuttman



Tue, 07 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS



Quote:
> Is there any way to set up labels from a table that contains
> names with middle Initials and without middle initials that
> will print uniformly?

Use calculated field like this:

        [First Name]+ " "+[Init]+" "+[Last Name]



Tue, 07 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Another Point to consider is a 2nd address (suite # or such) that alot of
mailing addresses have. Use LineSqueeze to take care of non-existent 2nd
address, but make sure you have enough room to fit it on the label if a
2nd address is there. Just place the 2nd address mask under the regular
address mask and specify LineSqueeze, then specify YES to remove lines with
blank fields, then specify FIXED to maintain label length.

-Ray-



Quote:



>> Is there any way to set up labels from a table that contains
>> names with middle Initials and without middle initials that
>> will print uniformly?

>Use calculated field like this:

>    [First Name]+ " "+[Init]+" "+[Last Name]

______________________________________

http://www.nauticom.net/www/rsummerl

The.Question = (ToBe || NOT ToBe) ;
______________________________________



Tue, 07 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Quote:



> >> Is there any way to set up labels from a table that contains
> >> names with middle Initials and without middle initials that
> >> will print uniformly?

> >Use calculated field like this:

> >       [First Name]+ " "+[Init]+" "+[Last Name]

> ______________________________________

> http://www.nauticom.net/www/rsummerl

> The.Question = (ToBe || NOT ToBe) ;
> ______________________________________

Raymond,

Thanks for prompt reply... but unfortunately your formula does
not solve the problem.  When the Middle Initial Field is empty,
it will leave an extra blank space between the first & second names.
I did find the the solution on one of the Pdox tech notes.. that is
to use the command "immediate If"" (IIF) in calc field.. e.g.
IIF(IsBlank(MI) true formula, false formula)..
Thanks,again.
Burt Stuttman



Fri, 10 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Quote:
>       [First Name]+ " "+[Init]+" "+[Last Name]

Try in the calculated field ->  

iif(isblank([Init]),[First Name]+" "+[Last Name],[First Name]+" "+[Init]+"
"+[Last Name])
--

==================================================                        
Scott Simonson from Franklin WI

 Web Page: http://www.execpc.com/~scoots                            

**************************************************
******** Way to Go Green Bay Packers *************
********      Superbowl Champs       *************
**************************************************
==================================================



Quote:



> > >> Is there any way to set up labels from a table that contains
> > >> names with middle Initials and without middle initials that
> > >> will print uniformly?

> > >Use calculated field like this:

> > >       [First Name]+ " "+[Init]+" "+[Last Name]

> > ______________________________________

> > http://www.nauticom.net/www/rsummerl

> > The.Question = (ToBe || NOT ToBe) ;
> > ______________________________________
> Raymond,

> Thanks for prompt reply... but unfortunately your formula does
> not solve the problem.  When the Middle Initial Field is empty,
> it will leave an extra blank space between the first & second names.
> I did find the the solution on one of the Pdox tech notes.. that is
> to use the command "immediate If"" (IIF) in calc field.. e.g.
> IIF(IsBlank(MI) true formula, false formula)..
> Thanks,again.
> Burt Stuttman



Sun, 12 Sep 1999 03:00:00 GMT
 LABELS PDOX 4.02 DOS

Quote:



> > >> Is there any way to set up labels from a table that contains
> > >> names with middle Initials and without middle initials that
> > >> will print uniformly?

> > >Use calculated field like this:

> > >       [First Name]+ " "+[Init]+" "+[Last Name]

> Thanks for prompt reply... but unfortunately your formula does
> not solve the problem.  When the Middle Initial Field is empty,
> it will leave an extra blank space between the first & second names.
> I did find the the solution on one of the Pdox tech notes.. that is
> to use the command "immediate If"" (IIF) in calc field.. e.g.
> IIF(IsBlank(MI) true formula, false formula)..

A simpler solution. Use a calculated field:
[first name]+" "+ltrim([init]+" ")+[last name]

--

        A U C K L A N D   D E B A T I N G   A S S O C I A T I O N   (Inc)
Interested in debating, public speaking or adjudicating in Auckland?



Tue, 21 Sep 1999 03:00:00 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. Pdox 3.5 vs.Pdox 4.02 vs. Pdox 4.5

2. Pdox DOS 4.02 and Win XP

3. TKMenu substitute for PDOX DOS 4.02?

4. PDOX DOS 4.02 Print File question

5. Pdox 4.02 DOS - File Locking Problem - Steve Green

6. Help Dos Pdox 4.02 Application Workshop

7. Importing Text Files into Pdox 4.02 Tables

8. is it possible to make a touchscreen ap with pdox 4.02

9. Pdox 4.02 movement key problem

10. JDBC driver for Paradox 4.02 (yup, DOS)?

11. Connecting to Paradox 4.02 (DOS) using VB4

12. Problems with Paradox DOS after upgrade from 3.5 to 4.02


 
Powered by phpBB® Forum Software