Text Box invisible when empty

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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
 
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

Fons Ponsioen said:
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


.
Click to expand...
Click to expand...
 
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

Fons Ponsioen said:
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


.
Click to expand...
Click to expand...
 
Back
Top