Sergey Kornilov 3/29/2003 | |
You can do this if you have some unique value in your last line that identifies this line. For example if you have a word Totalin some column of the last row it can be used to highlight this row. |
M
|
mwill9872 author 3/30/2003 |
here is a link to a sample: |
Sergey Kornilov 3/31/2003 | |
Here is what you can do:
DO UNTIL rsData.eof OR iNumberOfRows>=nPageSize ' To insure that every other one is shaded If iShadeTheDetail = 0 then sShadeClass = "class=shade" iShadeTheDetail = 1 Else sShadeClass = "" iShadeTheDetail = 0 End If if rsData("Location") = "TOTAL BILLED" then sShadeClass = "class=totalline"
|
M
|
mwill9872 author 4/3/2003 |
this worked great! perfect.... thanks!!! |