hide label in subreport within report - microsoft.public.access.reports

I have a report which utilizes a subreport for the information. within the subreport is a textbox named "InTol". If the textbox has "IN", I need to hide a label named "InTolerance", if the textbox has "Out" I need the label visible. I know the below code will work to make the label visible or not. If Me!InTol = "OUT" Then Me!InTolerance.Visible = True Else Me!InTolerance.Visible = False End If My question is where do put this code in the subreport so it will be read for each record in the report -- Rick

Rick Try the Format event of the section of the sub-report where the control is located (probably in the detail section), but could be in a group header or footer. ---- HTH Dale "rbeach" wrote: > I have a report which utilizes a subreport for the information. within the > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > a label named "InTolerance", if the textbox has "Out" I need the label > visible. I know the below code will work to make the label visible or not. > > If Me!InTol = "OUT" Then > Me!InTolerance.Visible = True > Else > Me!InTolerance.Visible = False > End If > > My question is where do put this code in the subreport so it will be read > for each record in the report > -- > Rick

I have tried placing this code everywhere, but this only sets to what the first record is set to. If the first record is set to "Out" then all records display the label. If the first record is set to "IN" then all the records hide the label. -- Rick "Dale Fye" wrote: > Rick > > Try the Format event of the section of the sub-report where the control is > located (probably in the detail section), but could be in a group header or > footer. > > ---- > HTH > Dale > > > > "rbeach" wrote: > > > I have a report which utilizes a subreport for the information. within the > > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > > a label named "InTolerance", if the textbox has "Out" I need the label > > visible. I know the below code will work to make the label visible or not. > > > > If Me!InTol = "OUT" Then > > Me!InTolerance.Visible = True > > Else > > Me!InTolerance.Visible = False > > End If > > > > My question is where do put this code in the subreport so it will be read > > for each record in the report > > -- > > Rick

I can't imagine why the suggestion didn't work if you used the On Format event of the section containing the control. However, you could probably do this without code by changing your label to a text box with a control source of: =IIf([InTol] = "OUT","Out of Tolerance" , Null) -- Duane Hookom Microsoft Access MVP "rbeach" wrote: > I have tried placing this code everywhere, but this only sets to what the > first record is set to. If the first record is set to "Out" then all records > display the label. If the first record is set to "IN" then all the records > hide the label. > -- > Rick > > > "Dale Fye" wrote: > > > Rick > > > > Try the Format event of the section of the sub-report where the control is > > located (probably in the detail section), but could be in a group header or > > footer. > > > > ---- > > HTH > > Dale > > > > > > > > "rbeach" wrote: > > > > > I have a report which utilizes a subreport for the information. within the > > > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > > > a label named "InTolerance", if the textbox has "Out" I need the label > > > visible. I know the below code will work to make the label visible or not. > > > > > > If Me!InTol = "OUT" Then > > > Me!InTolerance.Visible = True > > > Else > > > Me!InTolerance.Visible = False > > > End If > > > > > > My question is where do put this code in the subreport so it will be read > > > for each record in the report > > > -- > > > Rick

Duane, I have made the changes per your suggestion and this works. I still do not unerstand why the code did not work in the On Format event. -- Rick "Duane Hookom" wrote: > I can't imagine why the suggestion didn't work if you used the On Format > event of the section containing the control. > > However, you could probably do this without code by changing your label to a > text box with a control source of: > =IIf([InTol] = "OUT","Out of Tolerance" , Null) > > -- > Duane Hookom > Microsoft Access MVP > > > "rbeach" wrote: > > > I have tried placing this code everywhere, but this only sets to what the > > first record is set to. If the first record is set to "Out" then all records > > display the label. If the first record is set to "IN" then all the records > > hide the label. > > -- > > Rick > > > > > > "Dale Fye" wrote: > > > > > Rick > > > > > > Try the Format event of the section of the sub-report where the control is > > > located (probably in the detail section), but could be in a group header or > > > footer. > > > > > > ---- > > > HTH > > > Dale > > > > > > > > > > > > "rbeach" wrote: > > > > > > > I have a report which utilizes a subreport for the information. within the > > > > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > > > > a label named "InTolerance", if the textbox has "Out" I need the label > > > > visible. I know the below code will work to make the label visible or not. > > > > > > > > If Me!InTol = "OUT" Then > > > > Me!InTolerance.Visible = True > > > > Else > > > > Me!InTolerance.Visible = False > > > > End If > > > > > > > > My question is where do put this code in the subreport so it will be read > > > > for each record in the report > > > > -- > > > > Rick

I don't understand either. I would probably set a Break Point and step through the code to determine what's going on. -- Duane Hookom Microsoft Access MVP "rbeach" wrote: > Duane, > > I have made the changes per your suggestion and this works. I still do not > unerstand why the code did not work in the On Format event. > -- > Rick > > > "Duane Hookom" wrote: > > > I can't imagine why the suggestion didn't work if you used the On Format > > event of the section containing the control. > > > > However, you could probably do this without code by changing your label to a > > text box with a control source of: > > =IIf([InTol] = "OUT","Out of Tolerance" , Null) > > > > -- > > Duane Hookom > > Microsoft Access MVP > > > > > > "rbeach" wrote: > > > > > I have tried placing this code everywhere, but this only sets to what the > > > first record is set to. If the first record is set to "Out" then all records > > > display the label. If the first record is set to "IN" then all the records > > > hide the label. > > > -- > > > Rick > > > > > > > > > "Dale Fye" wrote: > > > > > > > Rick > > > > > > > > Try the Format event of the section of the sub-report where the control is > > > > located (probably in the detail section), but could be in a group header or > > > > footer. > > > > > > > > ---- > > > > HTH > > > > Dale > > > > > > > > > > > > > > > > "rbeach" wrote: > > > > > > > > > I have a report which utilizes a subreport for the information. within the > > > > > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > > > > > a label named "InTolerance", if the textbox has "Out" I need the label > > > > > visible. I know the below code will work to make the label visible or not. > > > > > > > > > > If Me!InTol = "OUT" Then > > > > > Me!InTolerance.Visible = True > > > > > Else > > > > > Me!InTolerance.Visible = False > > > > > End If > > > > > > > > > > My question is where do put this code in the subreport so it will be read > > > > > for each record in the report > > > > > -- > > > > > Rick

Can you copy the code from the sub-forms code module and paste it here. Maybe we can pick-up on something. ---- HTH Dale "rbeach" wrote: > Duane, > > I have made the changes per your suggestion and this works. I still do not > unerstand why the code did not work in the On Format event. > -- > Rick > > > "Duane Hookom" wrote: > > > I can't imagine why the suggestion didn't work if you used the On Format > > event of the section containing the control. > > > > However, you could probably do this without code by changing your label to a > > text box with a control source of: > > =IIf([InTol] = "OUT","Out of Tolerance" , Null) > > > > -- > > Duane Hookom > > Microsoft Access MVP > > > > > > "rbeach" wrote: > > > > > I have tried placing this code everywhere, but this only sets to what the > > > first record is set to. If the first record is set to "Out" then all records > > > display the label. If the first record is set to "IN" then all the records > > > hide the label. > > > -- > > > Rick > > > > > > > > > "Dale Fye" wrote: > > > > > > > Rick > > > > > > > > Try the Format event of the section of the sub-report where the control is > > > > located (probably in the detail section), but could be in a group header or > > > > footer. > > > > > > > > ---- > > > > HTH > > > > Dale > > > > > > > > > > > > > > > > "rbeach" wrote: > > > > > > > > > I have a report which utilizes a subreport for the information. within the > > > > > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > > > > > a label named "InTolerance", if the textbox has "Out" I need the label > > > > > visible. I know the below code will work to make the label visible or not. > > > > > > > > > > If Me!InTol = "OUT" Then > > > > > Me!InTolerance.Visible = True > > > > > Else > > > > > Me!InTolerance.Visible = False > > > > > End If > > > > > > > > > > My question is where do put this code in the subreport so it will be read > > > > > for each record in the report > > > > > -- > > > > > Rick

Did you put the code in the Format event of the sub-form, or the main form? What version of Access are you using? ---- Dale "rbeach" wrote: > I have tried placing this code everywhere, but this only sets to what the > first record is set to. If the first record is set to "Out" then all records > display the label. If the first record is set to "IN" then all the records > hide the label. > -- > Rick > > > "Dale Fye" wrote: > > > Rick > > > > Try the Format event of the section of the sub-report where the control is > > located (probably in the detail section), but could be in a group header or > > footer. > > > > ---- > > HTH > > Dale > > > > > > > > "rbeach" wrote: > > > > > I have a report which utilizes a subreport for the information. within the > > > subreport is a textbox named "InTol". If the textbox has "IN", I need to hide > > > a label named "InTolerance", if the textbox has "Out" I need the label > > > visible. I know the below code will work to make the label visible or not. > > > > > > If Me!InTol = "OUT" Then > > > Me!InTolerance.Visible = True > > > Else > > > Me!InTolerance.Visible = False > > > End If > > > > > > My question is where do put this code in the subreport so it will be read > > > for each record in the report > > > -- > > > Rick

Similiar Articles:

hide label in subreport within report - microsoft.public.access ...
I have a report which utilizes a subreport for the information. within the subreport is a textbox named "InTol". If the textbox has "IN", I need to hide a label named ...

hide subreport in the report under condition - microsoft.public ...
hide label in subreport within report - microsoft.public.access ... hide subreport in the report under condition - microsoft.public ... Conditional Label Caption (Report ...

How to reference main report field in subreport calculation ...
Access2003 ... hide label in subreport within report - microsoft.public.access ... How to reference main report field in subreport calculation ... hide label in subreport ...

Display "No details" if subreport has no records ...
Display "No details" if subreport has no records ..... like to display something like "No details" in a textbox ... hide label in subreport within report - microsoft ...

Subreport On No Data event - microsoft.public.access.modulesdaovba ...
hide label in subreport within report - microsoft.public.access ... Rick Try the Format event of the section of the sub-report where the ... No Data - GrapeCity My company ...

hiding a section of sub-report with code - microsoft.public.access ...
hide label in subreport within report - microsoft.public.access ... Rick Try the Format event of the section of the sub-report ... My question is where do put this code in ...

Suppress Main Section Based on Subreport - microsoft.public ...
hide label in subreport within report - microsoft.public.access ..... Label & Text Box in Report based ... Microsoft Access question: Hide Label in Main Report if ...

Hide Sub Report(s) when records are null - microsoft.public.access ...
hide label in subreport within report - microsoft.public.access ... Hide Sub Report(s) when records are null - microsoft.public.access ... hide label in subreport within ...

Hiding Controls in a report - microsoft.public.access.reports ...
hide label in subreport within report - microsoft.public.access ..... My company wants to hide a subreport if it has no data, so that subreport labels don't even appear ...

Hide a field in a report - microsoft.public.access.reports ...
hide label in subreport within report - microsoft.public.access ... Access2003 ... hide label in subreport within report - microsoft.public.access ...

hide label in subreport within report DataBase
I have a report which utilizes a subreport for the information. within the subreport is a textbox named "InTol". If the textbox has "IN", I need to hide a label named ...

Hide Subreport on No Data DataBase - DataBase Discussion List ...
... of the subreport. I would use a text box with a control source like: =IIf(sbrptCtrl.Report.HasData, "Label ... on the main report. I also want to hide the subreport ...

Jan's Access Forms & Reports: Subreports
to add a subreport using drag-and-drop to add a subreport to report's Detail to hide duplicate ... view inside. Delete the two labels from the Report Header.

Microsoft Access: Hide Label in Main Report if Subreport has no ...
database.itags.org: Microsoft Access question: Hide Label in Main Report if Subreport has ... about how to hide a label if a text boxis Null within a section of the report.

7/26/2012 12:07:39 PM