SHow/NoShow ??????

[Savant]

Hey, i'm creating a report that sets up a mailing form (for folding and
envelopes).



I have 1 iffy field, Apt#



I want it so that, if there is no Apt#, the "Label" Apt# is blank, and
if there is an Apt#, the "Label" Apt# is Visible...



Any help would be greatly appreciated



Thanks

 

[Fons Ponsioen]

I would recommend change the label field to a text field.
Set the source of this (former label) field to:
=IIF([Appt#] is null,"","Apt#")
now leave the text field for the actual appartment number
just as you had it.
This should work fine.
Take care
Fons

 

[Savant]

Thanks a whole lot..



I could have sworn that I had that condition written for the text field,
but hmm..Oh well.



Thanks again