Suggestion to hide not applicable selections from report RRS feed

  • Question

  • Hello,

    I'm designing a report, that is generated based on a user selection form.

    This form is comprised of multiple subforms.

    Each subform has categories that may or may not be applicable.

    I want to generate a final clean report, that is a formal document, that only shows what is applicable.

    I'm relatively new to access and wanted to get feedback on the best way to do this, if anyone could offer a suggestion I'd be extremely grateful.

    For example:

    Form MAIN has form a and form b.

    Form a has 3 categories. Two of these categories have values (Category FormA-1, Category Form A-2). one is null, as it is not applicable. Then imagine a similar scenario for form b.

    On the report that is generated, all tied together by a corresponding certificate ID through the main and subforms, I only want it to show exactly what is applicable and nothing more. I primarily want the spacing on the report to be reduced so just making "is visible" via VBA won't help as I need it to shrink to only show relevant data.

    Thank you so much for any suggestions.



    Monday, May 27, 2019 10:36 PM

All replies

  • I don't fully understand what you are trying to accomplish, but:
    * It should be possible to remove Null results from the report query:
    select * from someTable where someField is not null

    * The CanShrink property can be used to shrink null fields to zero.

    -Tom. Microsoft Access MVP

    Tuesday, May 28, 2019 4:33 AM