Line Numbering Woes

[Michael]

Hi!

Hopefully someone can help me out as I've been scratching my head on
this one and can't figure it out.

I'm putting together a report that will contain line numbers.

I've implemented the suggestions located at
http://support.microsoft.com/?kbid=209567, but need to enhance this
feature a little.

Is it possible to change the order of the items based on a condition on
the record? (ie when a field value goes over 100, reverse the count and
set it back when the value dips below 100):

#1 Item 50
#2 Item 75
#3 Item 100
#2 Item 125 // line number decreased because the value is over 100
#3 Item 0 // line number increased because the value is under 100

I've tried setting the control source of the textbox containing the line
numbers (txtNumbering) based on a value in the Format event, but I can't
change an item's control source on the fly.

Part 2 of this is how to start the numbering at a certain level, so
instead of starting the numbering at 1, it would start at 67 (for
example). To solve this one I created a textbox in the report header
(txtStartValue) and set it to my arbitrary value (66), and changed the
control source for txtNumbering to =1 + [txtStartValue], but this gave
me 67, and then 134, etc. This was a dissapointing, though not
unexpected result.

Any help would be greatly appreciated, though I fear that this is
something that goes beyond Access's reporting capabilities and I may
have to move up to Crystal or a similar reporting tool.

Michael

....
If replying, remove the _cluck from my username.

 

[Allen Browne]

Set the ControlSource of the text box to:
=(IIf([Field1] > 100, -1, 1)

 

[Michael]

That worked brilliantly, thanks!! Did a big "D'oh!" when I saw that one
since I should have figured that out myself.


Any thoughts on setting a starting value other than 1?

Thanks!

Michael

....
If replying, remove the _cluck from my username.