Report Label Propoerties

[demax182]

How's everybody doing? Got a quick question. I have a report used to print out order forms. I have a field called "status" which is used to tell whether the report has been revised or cancelled. I created two labels in my report, one called "REVISED" and the other "CANCELLED". Now my dilemna. I have the following code in my "on_format" event for my details section:

If Me.txtStatus.Value = "revised" then
Me.lblRevised.Visible = True
End If

And a similar code for "Me.txtStatus.Value = "cancelled""

Something like this works for a form, but it doesn't seem to work on a report? Because everything is still showing up when I put this code in. What am I doing wrong? As always, thanks in advance for all the help.

 

[TheAceMan1]

Hiow are ya demax182 . . . . .

We can handle this here, but for future reference the [blue]Report Guru's[/blue] hang out in the [blue]Microsoft: Access Reports Forum![/blue]

It appears [blue]status[/blue] is not in the detail section. The code should be in the same [blue]Format Event[/blue] of the section as [blue]status[/blue]. So make it so, but use the following (just better consolidation):

[blue]If Me.txtStatus.Value = "revised" then
   Me.lblRevised.Visible = True 
ElseIf Me.txtStatus.Value = "cancelled" then
   Me.lblCancelled.Visible = True
End If[/blue]

See Ya! . . . . . .

 

[demax182]

Thank you! I'll give it a try. I'll go to that forum for report questions from now on.