Making controls non visible - driving me insane!!

[Louise]

This is a similar problem to RpbertS's listed a little while ago but unfortunately not yet answered.

I have a report with 2 fields that are bound ole objects (scanned signatures). The second signature needs to be printed only if the report contains letters that are barcoded.

So I'm trying to do a very simple onOpen event that looks if all the barcoded fields (there are 4 fields) are null, or value of zero, and if they all are then the second signature ole is not visible.

I just don't seem to be able to get it right. I assumed it would be as simple as the following:

------Code------
If IsNull(Me!Field1) And IsNull(Me!Field2) And _
IsNull(Me!Field3) And IsNull(Me!Field4) Then
Me!Signature2.Visible = False
End If
------Code------

If anyone could tell me where I'm going wrong I'll be a much saner person!

Thanks

 

[jstutz]

If you are using the OnOpen event of your form, you may instead try using the OnFormat event for the Report's detail section (to get to this event, in design view, click on the Detail Section Bar of the report). The OnFormat event occurs after the OnOpen event and right before Access formats the data on the report to be previewed or printed.

Hopefully this will solve your problem! Let me know if not!

Jamie

 

[RpbertS]

hey louise yah I'd be much saner to if a solution could be found Im going to ask the people in the VBA forum if they know how access handles controls because it appears to be very different than how VB handles it, so check that forum also maybe will get an answer there.

Rpb