simple report problem.......

[rdrunner40]

Hello

I have the following issue....

I have a report called bk3.

On this report i have a label called PROGRAMME_CREDIT_RATING
and basically i have three other fields that have contain data

What i want to do is make this label invisible if there is no data in these fields .....

can anybody help me....

the underlying query that i use for the report is called .... query2 and the fields that i wish to check are as follows....

PROGRAMME_CREDIT_RATING,PROGRAMME_MARK, & PROGRAMME_CREDIT_AWARDED

so if all of these fields are blank i want to make the lablel called PROGRAMME_CREDIT_RATING invisible

I want to do this using VBA i hope .....

any help appreciated

regards

Murray

 

[M8KWR]

use the onformat procedure use some code like: -

If Me.PROGRAMME_CREDIT_RATING = "" Or IsNull(Me.PROGRAMME_CREDIT_RATING ) Then
'list the fields here you want to visible = true
End If

Hope this helps.