Generate alternate color table

Results 1 to 2 of 2

Thread: Generate alternate color table

  1. #1
    Lee Pooi Ling Guest

    Default Generate alternate color table

    Can somebody tell me how to generate a table with alternate row color ? and control 10 number of records in a table ?

  2. #2
    Join Date
    Dec 1969

    Default RE: Generate alternate color table

    When your looping through your recordset (I assume that&#039s what your doing), have a boolen variable that is set to true for the first color and false for the second. During each itteration change the boolean. For example (mostly psuedo code):<BR><BR>dim myBoolean<BR>&#039assuming rs is your recordset object<BR><BR>myBoolean = true<BR>while not rs.eof<BR> if myBoolean then<BR> &#039set table row to first color and fill in data<BR> myBoolean = not(myBoolean)<BR> else<BR> &#039set table row to second color and fill in data<BR> myBoolean = not(myBoolean)<BR> end if<BR>wend<BR><BR>As for as control 10 number of records, I think what your looking for can be found by searching for an article on &#039paging&#039 here in 4Guys.<BR><BR>If you need any more help with this email me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts