Text Box invisible when empty

[Jim]

I have a query which returns dates for initiated new members, but some
members will
not have dates in the initiated field.
So when I print the report I would like the date and label displayed if
there is a date to show,
but when there is not a date the label and text box is to be set to
invisible.
The format of the initiated text box is set to date format, does this need a
macro to make
this work?
Jim

 

[Fons Ponsioen]

Hi Jim.
One approach could be to change the label to a text boxand
in it set the data source to
=IIF([Initiated]is null,"","LabelName")
than you can set the can shrink property for the report
band to yes and this should give the desired result.
Hope this helps
Fons

 

[Jim]

Hi Fons
Thanks for your idea, it works about 60% of the time, but the 'new' text box
is sometimes invisible even when the initiated text box is populated.
Nearly there I suspect.
Any ideas?
Thanks for your time on this one.
Jim

Hi Jim.
One approach could be to change the label to a text boxand
in it set the data source to
=IIF([Initiated]is null,"","LabelName")
than you can set the can shrink property for the report
band to yes and this should give the desired result.
Hope this helps
Fons

-----Original Message-----
I have a query which returns dates for initiated new members, but some
members will
not have dates in the initiated field.
So when I print the report I would like the date and label displayed if
there is a date to show,
but when there is not a date the label and text box is to be set to
invisible.
The format of the initiated text box is set to date format, does this need a
macro to make
this work?
Jim


.

 

[Jim]

Hi Fons
Thanks for your idea, it works about 60% of the time, but the 'new' text box
is sometimes invisible even when the initiated text box is populated.
Nearly there I think.
Any ideas?
Thanks for your time on this one.
Jim

Hi Jim.
One approach could be to change the label to a text boxand
in it set the data source to
=IIF([Initiated]is null,"","LabelName")
than you can set the can shrink property for the report
band to yes and this should give the desired result.
Hope this helps
Fons

-----Original Message-----
I have a query which returns dates for initiated new members, but some
members will
not have dates in the initiated field.
So when I print the report I would like the date and label displayed if
there is a date to show,
but when there is not a date the label and text box is to be set to
invisible.
The format of the initiated text box is set to date format, does this need a
macro to make
this work?
Jim


.