Makes sense....I tried it just now though and it still doesn't work :( Any other suggestions?
L. --- In [email protected], Lonnie Johnson <[EMAIL PROTECTED]> wrote: > > 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] >
