Display only fields containing data in a report 1

[markswan20]

Hi everyone.

Is it possible when using reports to only display data that contain information?

My report has 7 fields 1 field will always have information in but the others are blank when i print my report i only want it to print the lines with data in the fields so blank ones are not.

Is this possible?

Kind Regards
Mark

 

[ZmrAbdulla]

Something like this?
[tt]
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.FieldName = "" Then Cancel= True
End Sub
[/tt]

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[markswan20]

Thank you for you reply ZmrAbdulla

Where would I attach the code?

Kind Regards
Mark

 

[ZmrAbdulla]

Just paste it into the code window. Also remember to change the "FieldName" to actual field name

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[markswan20]

Apologies if I sound a little slow,

When you say code window, is that it the top left corner of the report?

If so under which option within the window?

Apologies

Kind regards
Mark

 

[ZmrAbdulla]

When you are at the design view of the report

Menu VIEW > CODE


________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[markswan20]

Thank you very much Zameer.

It works better than expected.

I have a command button that prints my report. Makes life easy, is it possible to have a form popup that lets you specify the date range you want displaying on the report?

Thanks very much

Mark

 

[ZmrAbdulla]

Open the Northwind sample DB that ships with MS Access. It has the sample that you require

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.