Move your code to the report headers format event procedure. When the Report Open event is fired there are no values in the textboxes yet.
May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: winpins <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, January 31, 2007 9:29:39 PM Subject: [ms_access] Invisible Columns in Report Hello all: This is the code I've placed in "On Open" on a Report I have. The boxes (columns) are not visible when the Report opens, however, when Select is chosen in the Filter Box, they do not reappear. Any suggestions to make this work? Private Sub Report_Open( Cancel As Integer) 'Make 2 Columns in report invisible unless Auction is chosen to filter by. Me!Label80.Visible = False Me!Box86.Visible = False Me!Label79.Visible = False Me!Box85.Visible = False Select Case Me.Status 'When AUCTION is selected to filter by in STATUS, the 2 columns become visible. Case "Auction" Me!Label80.Visible = True Me!Box86.Visible = True Me!Label79.Visible = True Me!Box85.Visible = True Case Else 'nothing End Select End Sub Thanks much, L. ____________________________________________________________________________________ Need a quick answer? Get one in minutes from people who know. Ask your question on www.Answers.yahoo.com [Non-text portions of this message have been removed]
