Is there still a question here?

--
Duane Hookom
MS Access MVP


"Per Erik" wrote in message
...
I have created a results page of a report in Access 2007.
I want to make a "sign" - like: **** - AFTER the first third of the
report. So if there are
33 participants, I would like it to be characterized by the eleventh.
Is this
possible in a report?
Hope someone can help me with this!

"Duane Hookom" wrote:

Assuming you have a control named "Mark" that you want to make
visible....

Add a text box to the Report Header section:
Name: txtCountAll
Control Source: =Count(*)
Add a text box to the detail section:
Name: txtRunCount
Control Source: =1
Running Sum: Over All
Visible: No
Add code to the On Format of the detail section:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Mark.Visible = (Me.txtRunCount Mod Me.txtCountAll \ 3 = 0)
End Sub

--
Duane Hookom
Microsoft Access MVP


"Per Erik" wrote:

Hey! First, sorry my bad English!
I have created a results page of a report in Access 2007.
I want to make a mark AFTER the first third of the report. So if there
are
33 participants, I would like it to be characterized by the eleventh.
Is this
possible in a report?
Hope someone can help me with this!