|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 1st, 2007, 06:52 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Hiding a Null Field and it's label in a Subreport
Hi there,
I am trying to get a field and its' label to not be visible on the subreport if the field is null. Does anyone know how to do this? Its driving me crazy. 
|
|
#2
August 1st, 2007, 07:16 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Hiding a Null Field and it's label in a Subreport
Open the report in design view.
Click on the control ("fields" are in tables). Open the control's properties. Find the Can Grow and Can Shrink properties -- and set them both to Yes. Click on the section in which the control sits. Set the section's Can Grow and Can Shrink properties to Yes. NOTE: if there are any controls in the report that are aligned horizontally with the control in question, they can "hold open" the control, even if it has Null. NOTE2: you don't have to do this on the associated label. You DO have a label attached to the control, right?! Regards Jeff Boyce Microsoft Office/Access MVP "Krispy" wrote in message ... Hi there, I am trying to get a field and its' label to not be visible on the subreport if the field is null. Does anyone know how to do this? Its driving me crazy.
|
|
#3
August 1st, 2007, 07:46 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Hiding a Null Field and it's label in a Subreport
Thank you so much for your quick reply. I love this site!
Your suggestion worked for the control in the detail, but not for the its' label in the the header. "Jeff Boyce" wrote: Open the report in design view. Click on the control ("fields" are in tables). Open the control's properties. Find the Can Grow and Can Shrink properties -- and set them both to Yes. Click on the section in which the control sits. Set the section's Can Grow and Can Shrink properties to Yes. NOTE: if there are any controls in the report that are aligned horizontally with the control in question, they can "hold open" the control, even if it has Null. NOTE2: you don't have to do this on the associated label. You DO have a label attached to the control, right?! Regards Jeff Boyce Microsoft Office/Access MVP "Krispy" wrote in message ... Hi there, I am trying to get a field and its' label to not be visible on the subreport if the field is null. Does anyone know how to do this? Its driving me crazy.
|
|
#4
August 1st, 2007, 09:08 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Hiding a Null Field and it's label in a Subreport
Add a line of code to the section's Format event:
Me.textbox.Visible = Not IsNull(Me.textbox) -- Marsh MVP [MS Access] Krispy wrote: Thank you so much for your quick reply. I love this site! Your suggestion worked for the control in the detail, but not for the its' label in the the header. "Jeff Boyce" wrote: Open the report in design view. Click on the control ("fields" are in tables). Open the control's properties. Find the Can Grow and Can Shrink properties -- and set them both to Yes. Click on the section in which the control sits. Set the section's Can Grow and Can Shrink properties to Yes. NOTE: if there are any controls in the report that are aligned horizontally with the control in question, they can "hold open" the control, even if it has Null. NOTE2: you don't have to do this on the associated label. You DO have a label attached to the control, right?! Regards Jeff Boyce Microsoft Office/Access MVP "Krispy" wrote in message ... Hi there, I am trying to get a field and its' label to not be visible on the subreport if the field is null. Does anyone know how to do this? Its driving me crazy.
|
|
#5
August 1st, 2007, 10:02 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Hiding a Null Field and it's label in a Subreport
IT WORKS!!!! Thank you. I am doing a dance in my cubicle right now.
"Marshall Barton" wrote: Add a line of code to the section's Format event: Me.textbox.Visible = Not IsNull(Me.textbox) -- Marsh MVP [MS Access] Krispy wrote: Thank you so much for your quick reply. I love this site! Your suggestion worked for the control in the detail, but not for the its' label in the the header. "Jeff Boyce" wrote: Open the report in design view. Click on the control ("fields" are in tables). Open the control's properties. Find the Can Grow and Can Shrink properties -- and set them both to Yes. Click on the section in which the control sits. Set the section's Can Grow and Can Shrink properties to Yes. NOTE: if there are any controls in the report that are aligned horizontally with the control in question, they can "hold open" the control, even if it has Null. NOTE2: you don't have to do this on the associated label. You DO have a label attached to the control, right?! Regards Jeff Boyce Microsoft Office/Access MVP "Krispy" wrote in message ... Hi there, I am trying to get a field and its' label to not be visible on the subreport if the field is null. Does anyone know how to do this? Its driving me crazy.
|
|
#6
August 4th, 2007, 06:00 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Hiding a Null Field and it's label in a Subreport
"Krispy" wrote
IT WORKS!!!! Thank you. I am doing a dance in my cubicle right now. Careful! Don't tip over that cactus plant! Ooops! :-) Larry
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
