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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hide rows if isnull(field)
I am trying to hide certain rows on the detail section of a report if the field value is null Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(contact_date) And action = "" Then Me.action.Properties("Visible") = False End If End Sub but this hides the Action...- sangathy
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
manipulate data displayed on report
I have a report which is based on a query. Need to hide some rows based on a criteria. For eg: the query returns fld1 fld2 fld3 ABC 3/1/2005 text1 ABC 10/3/2006 text2 DFG 10/10/2005 text3 EDF 3/4/2006 text4 When fld1 has the same value I want to display the latest record( fld2...- sangathy
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
-
Asking for parameter again in report
I have a report with a changing where clause for the recordsource. I am using DoCmd.OpenReport "Action", acPreview, , sqlCondition, , strfinal3 + "." & " Status: " + strfinal2 sqlCondition = " Year_entered BETWEEN 2003 AND 2004 " ( the year is input from user) The recordsourse for the...- sangathy
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
Allow scrolling in print preview
I have a report which ahs about 3 to 6 pages depending on data selected. Right now the user has to select the next tab on bottom left to go to next page of the report( in Print preview). Is there anyway to allow scrolling in report's preview ? Thanks, Sangeetha- sangathy
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
