Reference Sub Report

[Tallbloke]

Hi Guys,

I can't seem to get this to work....

If Reports![PackageReportNew]![PackageDayReportNew].Report!IsNull([Arrive2]) Then

Is the syntax correct or does the final! need to be followed by the field name?

Arrive2 is a Date / Time field.

Thanks!

 

[pbaldy]

The IsNull() needs to surround the entire reference to the report, not just the field name.

 

[Tallbloke]

Like this?

If IsNull(Reports![PackageReportNew]![PackageDayReportNew].Report![Arrive2]) Then

 

[Tallbloke]

Yup, got it, sorted thanks!

 

[pbaldy]

Happy to help!

 

[Tallbloke]

I've re-opened the thread as something isn't quite right. I was using that code to set the .visible property to hide empty fields (they have a border).

Whilst this works in print preview they aren't hidden when I generate a pdf....

Any ideas?

 

[pr2-eugin]

I think any formatting that you place in the OnFormat method will be available only in Preview mode !

Try OnLoad Or OnCurrent event. I am not 100% sure about it though.

 

[Tallbloke]

I think any formatting that you place in the OnFormat method will be available only in Preview mode !

Try OnLoad Or OnCurrent event. I am not 100% sure about it though.

The code is in the onload of the report.

 

[David R]

Are you in Private Sub Detail_Format ? I've certainly used that to hide fields from printing...

 

[Tallbloke]

Are you in Private Sub Detail_Format ? I've certainly used that to hide fields from printing...

That seems to work...will test some more and let you know!