vba code required for report

[princeofdumph]

hi,
i have created a report which shows a number of columns for each employee. however, not every column is relevant to any given employee. For example, lets say 'M' is an employee and columns 8 and 9 are irrelevant to him. but whenever i see Mr. M's report page, it shows these two columns in page header and their "zero" values in details section and so on for other employees.


I want a VBA code which hides such columns totally following some kind of condition for every employee. I think i'll have to put it in the On Print event line. but dont know how to write such a code and where exactly to put it to work. Can anyone help?

[Rawb]

There's probably some way to do it by setting the Column Header's (I'm assuming it's a Label?) .Visible property.

However, the easiest say, IMO is to just have a check in each Column that says If the column doesn't apply, print "N/A"

If you're hellbent on making the Label invisible, you'd probably put the code in the Report's OnOpen event. Maybe something like this (I haven't actually tried it, so I don't know if this will really work or not):

If Len([Column8] & vbNullString) = 0 Then
  Me!Label8.Visible = False
Else
  Me!Label8.Visible = True
End If

Assuming [Column8] is the name of the Table field containing the null data and that Label8 is the name of the Column Header you want to hide.

Generally speaking, I try to stay away from coding in Reports though so I don't know the exact syntax.