order number in the begining of every row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
how can I put an order number in front of every row I get on the report
(1,2,3....)
Also, is there any way I can make every second row to have gray background?
I want that 'table' feel.

Thank you

alek_mil
 
To nubmer the rows of a report, add a text box with these properties:
Control Source =1
Running Sum Over Group
Format General Number
Name txtCount

To make alternativing grey background for a report in Access 2000 or later,
add another text box the full size of the detail section. Use Conditional
Formatting (Format menu in report design view), and set Contidion 1 to an
expression such as this:
([txtCount] Mod 2) = 1
 
Back
Top