Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: vegasvic21
- Order by date
-
Hiding a Control in a Multipe column report
thanks lameid !!! your suggestion worked!! Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim rpt As Report Dim ctl As Control Set ctl = Me.txtDESC Set rpt = Me If rpt.Left < "1000" Then Me![txtDESC].Visible = True Else Me![txtDESC].Visible = False End If...- vegasvic21
- Post #8
- Forum: Microsoft: Access Reports
-
Hiding a Control in a Multipe column report
is there a way in VBA to say if a controls appears in a certain column hide it?- vegasvic21
- Post #6
- Forum: Microsoft: Access Reports
-
Hiding a Control in a Multipe column report
close i cant use a crosstab because i need 2 colum headings. the other idea wont work because i only have 3 controls. I have one query the report needs to be laid out like this Comp A Comp B Comp C Actual Budg Var Actual Budg Var Actual Budg Var...- vegasvic21
- Post #4
- Forum: Microsoft: Access Reports
-
Hiding a Control in a Multipe column report
Hey all I have a report that has data in the detail section like this: Customer Name Actual Budget Variance Telephone 50.00 60.00 10.00 Gas 30.00 20.00 -10.00 Now the report is a 3 column report so in the detail section there are thre customers...- vegasvic21
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
