Subreport has data 1

[jw5107]

I have a report with a sub-report. I need to make a text box bold on the main report when the sub-report has data.
Any examples or suggestions...?
Not sure how to set this up...???
Thanks in advance..!
jw5107

 

[Remou]

How about:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.[[i]subreport Name[/i]].Report.HasData Then
    Me.txtText.FontWeight = 700
Else
    Me.txtText.FontWeight = 400
End If
End Sub

 

[jw5107]

Remou,

I have tried your suggestion... I get an error stating that it cannot support this object.. and on de-bug it highlights
Me.Tail.FontWeight = 700

This is what I am working with:
If Me.PartsReqdMAIN.Report.HasData Then
Me.Tail.FontWeight = 700
Else
Me.Tail.FontWeight = 400
End If

Any other suggestions..???
Thanks for the quick response..!!
jw5107

 

[Remou]

Whst happens if you manually sent the font weight to bold?

 

[jw5107]

Remou,
Don't want the font to be bold all the time - only when the subreport has data.....
jw5107

 

[dhookom]

Is "Tail" the name of the text box or is it just a field name in your report's record source? What section did you add your code into?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jw5107]

dhookum,

"Tail" is the name of the textbox as well as a field name in the reports record source. I placed the code in the Detail Sections - on format event..

Do you think you can take a look at thread702-1272806 - when you get a chance...????
Need some mad skills to help me out with that one...!!
Thanks in advance for all of your help!!
jw5107

 

[dhookom]

Regarding the other thread, I don't know anything about Stephen's solution and don't really want to I guess if this was something that was significnt to my users I might take a look.

Did you get the original issue in this thread sorted out?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jw5107]

dhookum,

Thanks.

No I didn't get it sorted out. Still get the error message I stated earlier....

jw5107

 

[dhookom]

Change the name of the control to "txtTail" and change your code to see what happens. Also, have you compiled your code

http://www.access.hookom.net/Articles.htm?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jw5107]

dhookum,
Got it...!!
Thank you very much...!!!
jw5107