Share via

Remove null value fields from Access Report doesn't work

Anonymous
2016-10-18T20:13:09+00:00

I have an access 2010 report with many fields so I don't want them to show if they have a zero or null contents as the report won't fit on one page.  For example column 1 may be null for product A but has a value for product B.  So if I pulled data for Product A, I would only want to see data in Column 1 and hide and shrink column 2.  I have tried =IIf(IsNull([Field]),Null,"Field heading") and set the property to Can Shrink, but it doesn't work.

I tried making all the fields around it as can shrink but no success.

Thank you,

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-10-18T20:46:59+00:00

    It sounds like you are using multiple fields to store multiple products  -  That is wrong table structure for a Relational Database.

    You should have a related table for the multiple products and use form/subform for data entry and display.  In a report use subreports.

    Was this answer helpful?

    0 comments