=hidenullole([OPPhoto1])+hidenullole([OPPhoto2])
etcIs there a way to check through every object on my report and hide the ones missing.
Instructions I have used: Create a module ->
Expand|Select|Wrap|Line Numbers
- Option Explicit
- Function HideNullOle (ctl As Control)
- On Error Resume Next
- ctl.visible = Not IsNull (ctl
- If Err = 2427 Then ctl.visible = True
- End Function
I have also added unbound text boxes on the report to overlap the photos etc.
If you understand what I am getting at, I would really appreciate some help.
Thanks
LH