Can you shrink labels accompanying empty textboxes?

[Phil Stokes]

I have a report which will have a varying amount of fields filled in.
Sometimes many fields and more often less than half the fields. I would like
the blank fields to disappear in the report. By using CanShrink the textboxes
disappear but the accompanying labels do not thus spoiling the effect. I know
that I can do it other ways and am considering using g the data as a mail
merge in word or something like that but it would be great if I could do it
all on the report.

 

[Al Campagna]

Phil,
This may not be the most elegant solution, but works fine...
Using a text control named "SomeField"...
Select the label associated with SomeField, and using Format\Change
To...
change the label to a text control. (ex. name = SomeFieldLabel)
Set the Control Source for SomeFieldLabel to...
=IIf(IsNull([SomeField]),Null,"Some Field:")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Phil Stokes]

Thanks, that'll work fine.

Phil

Phil,
This may not be the most elegant solution, but works fine...
Using a text control named "SomeField"...
Select the label associated with SomeField, and using Format\Change
To...
change the label to a text control. (ex. name = SomeFieldLabel)
Set the Control Source for SomeFieldLabel to...
=IIf(IsNull([SomeField]),Null,"Some Field:")
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I have a report which will have a varying amount of fields filled in.
Sometimes many fields and more often less than half the fields. I would
like
the blank fields to disappear in the report. By using CanShrink the
textboxes
disappear but the accompanying labels do not thus spoiling the effect. I
know
that I can do it other ways and am considering using g the data as a mail
merge in word or something like that but it would be great if I could do
it
all on the report.