@anonymous: "Basically I am looking for a way to chage a label that is placed in front of a row in a report
So far I have concluded that I need to place code in details_format so it will fire for each record that is printed
What I have not been able to figure out is how to change the dispalyed text for either a label or a textbox on a report
What I was thinking was that I could do my IF THEN ELSE conditional stuff and do something like label3.caption = "text
to set what I wanted displayed based on my conditions.  For the life of me I can not find where I can chage this text and keep getting erros."
    @marshbarton: "<quote>
It sounds like you're on the right track here, but since you
didn't post your code or explain what errors you're getting,
it's impossible to guess what the problem might be.
The general idea for this kind of thing is something along
these lines (in the Detail section's Format event procedure:
	If somecondition Then
		label3.Caption = "text"
	Else
		label3.Caption = "other text"
	End If
Marsh
MVP [MS Access]"
{'source': 'USENET', 'other_information': '{"reply_count": 1, "forum_name": "microsoft.public.access.reports.20140630.mbox"}', 'file': 'data/output/usenet-microsoft.public.parquet'}