Make a field visible depending on a status within the report

[SamDemon]

Good morning / afternoon / evening (depending on when you are reading this!)

I have a report that produces invoices for our clients. What I am trying to achieve is to show one of the report fields to one half of our clients and hide it for the other half.

I am sure that there is a way of doing it, but searching on the web and through the help pages has brought me no luck.

I was thinking that it could be like something I did on one of my forms...

Private Sub Form_Current()

Me.TicketedOn.Visible = (Me.Status = "Ticketed")

End Sub

The fields that I am looking at in the report are as follows:-

TradingStatus = a or r
ClientReferenceNo = label and a combo box.

What we are trying to achieve is...

If tradingstatus = r
Then
ClientRefenceNo is not visible,

If tradingstatus = a
Then
ClientRefenceNo is visible,

Cheers in advance

Sam

It's just common sense, shame sense isn't common!

 

[Remou]

Have you looked at Conditional Formatting?

 

[SamDemon]

Its always something simple...

Cheers!!

Remou

It's just common sense, shame sense isn't common!