Numbering without number field in table

[John Spencer]

Add a new control to the detail section with the following property
settings:

Control Source: =1
Running Sum: Over All



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Michael]

What's an easy way to put a number field into the detail section of a report
that autonumbers the results. Such as if there are 8 records it has 1.
beside the first 2. beside the second, etc...?

 

[Michael]

If I use the rotated control label I'm going to have to apply the Running
Sum in a different way (probably with a small snippet). Do you know the
coding for that formatting?

 

[John Spencer]

I would TRY usings code in the Format event to set the caption of the Label
to the value of the control you've added.

Me.SomeLabel.Caption = Me.txtSequenceControl.Value

You can set the visible property of txtSequenceControl to False (no) and
that will hide it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Michael]

I'm curious because I've seen it other places. What does Me. stand for or
is it literally Me.? Reason I ask is I've tried it with other code samples
and it gives an error so I'm guessing I'm misunderstanding what I'm supposed
to type for Me.

 

[Michael]

Oh, I forgot, the control is not the problem. I can set the Control to =1
but I need to some other way to set the Running Sum to Overall.

 

[John Spencer]

Me. is shorthand reference for the current form or current report and can
only be used in class objects (the vba directly attached to a form or
report).

Running Sum is one of the properties of the control. It is on the same tab
as the Control Source property. If you don't see the properties dialog for
your controls, try selecting View: Properties and then clicking on the
control.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..