display on first occurrence of a change in the value

[adgorn]

How can I have a report display a text message upon the first occurence of a
change in the value of a field in the underlying table? In other words, the
field in this table has the same value for many records in a row, but all of
a sudden that can change and I want to alert the report reader once that
subsequent records are now reflecting these changed values. What I think I
need is some kind of switch that changes from say 0 to 1 when that first
change happens.
Thanks.
Alan

 

[Al Campagna]

adgon,
Use the Hide Duplicates propety set to Yes.
Only the first instance of each value will display.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[adgorn]

Doesn't work in this case since I am using IIF as the control source. What I
want is IIF record=0, don't print anything; IIF record=1, print my text
warning, but just the first time.