 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / September 2005Formatting Question?
I'm using Access 2003. I have a report that is based on a query, and ultimately contains 164 records on the report. Is there a method that would enable me to make every other record (row) grey. I would like to be able to have for example: Row 1 Grey Row 2 White Row 3 Grey Row 4 White So that reading the report is easier. TIA, _Bigred > I'm using Access 2003. > [quoted text clipped - 14 lines] > TIA, > _Bigred Make sure the BackStyle of each control is Transparent. Code the Detail Format event: If Me.Section(0).BackColor = vbWhite Then Me.Section(0).BackColor = 12632256 ' gray Else Me.Section(0).BackColor = vbWhite End If ==== If you wish each page to start with a white row, code the Page Header Format event: Me.Detail.BackColor = 12632256 'Reset color to Grey so that the first detail line will become white Change the colors as needed.  SignatureFred Please only reply to this newsgroup. I do not reply to personal email. You say code the detail format event ?? Am I suppose to right click on each field in the report and paste in your line of code or does it go somewhere else? Thanks for your time, _Bigred >> I'm using Access 2003. >> [quoted text clipped - 33 lines] > > Change the colors as needed. There is only one On Format event of the Detail Section. SignatureDuane Hookom MS Access MVP > You say code the detail format event ?? > [quoted text clipped - 41 lines] >> >> Change the colors as needed. Thanks that fixed the confusion.. worked like a charm. Here is a question .. My report has a unbound text box =1 (then I have it set to count over group). this is so when I run the report it give me a number list. Once I used the code below.. it makes all the fields on the report turn grey on every other record which is desired. but it does "not" make the unbound text box field turn grey it leaves it white. Is there a way to get around this or should I change the unbound text box into a permanent field in the source table/query. Thanks Again, _Bigred > There is only one On Format event of the Detail Section. > [quoted text clipped - 43 lines] >>> >>> Change the colors as needed. I expect Fredg's earlier comment "Make sure the BackStyle of each control is Transparent." should fix this. SignatureDuane Hookom MS Access MVP > Thanks that fixed the confusion.. worked like a charm. > [quoted text clipped - 59 lines] >>>> >>>> Change the colors as needed. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.