Report: Detail Format 
Author Message
 Report: Detail Format

If Me.Prolbl = "Foremore" Or Me.Prolbl = "marmot" Then
Me.test1.Top = 0
Me.test1.Height = 850.048
Me.Prolbl.Top = 420.48
Me.CoLbl.Visible = 1
Else
Me.test1.Top = 0
Me.Prolbl.Top = 0
Me.CoLbl.Visible = 0
Me.test1.Height = 0.01
End If

I am trying to hide a roe in my report when it meets a
certain criteria. Also so the the Detail Are shrinks so
there isn't that blank in the report



Wed, 24 Mar 2004 06:27:16 GMT  
 Report: Detail Format
Omit the row from the report 'before' the report is generated.

Consider using 'With' instead of 'Me' when referencing objects, as above,
restrict the data 'before' generating the Report.

Mary G

your No. 1 agony aunt


Quote:
> If Me.Prolbl = "Foremore" Or Me.Prolbl = "marmot" Then
> Me.test1.Top = 0
> Me.test1.Height = 850.048
> Me.Prolbl.Top = 420.48
> Me.CoLbl.Visible = 1
> Else
> Me.test1.Top = 0
> Me.Prolbl.Top = 0
> Me.CoLbl.Visible = 0
> Me.test1.Height = 0.01
> End If

> I am trying to hide a roe in my report when it meets a
> certain criteria. Also so the the Detail Are shrinks so
> there isn't that blank in the report



Thu, 25 Mar 2004 06:39:07 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. brainteaser of a report - detail format section

2. query/report Detail Format

3. Dynamic change of format of a detail control in a report

4. color decisions in detail format of a report

5. Report Detail section Format

6. Report Detail On Format or On Print Property

7. Formatting Report Detail Controls Based on Record

8. Reports - On Detail Format Event - Procedure too long

9. Format detail section of report

10. initiating a detail format in report from vba?


 
Powered by phpBB® Forum Software © phpBB Group