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