Displaying certain options in reports

[dcorey]

I have a form in which various tests to be performed on a sample are checked (some are simple check boxes, some are option groups). I am creating a report (which will be a sort of worksheet) which will show for the record only those tests that were checked in the form -- i.e. only those tests that need to be completed. The only way I can think of doing this is just coding a bunch of if else statements to hide or show the text boxes, but there are an awful lot of different tests. What is the best way to do this? Thanks!

 

[llkhoutx]

Use the conditional if (iff) function on your report.

 

[Chris RR]

This is sneaky, but should work if you have one test per report line.

Instead of coding the traditional label and text field set up, put two text boxes on the form for each test. Set "can shrink" to "Yes" for both.

Then, in the control source for your "label", do something like this (I may be a little off on the syntax...):

=Iif(Isnull([TextX]),"","Test X:")

Your actual text box for the field is just a regular text box. This way, if the field is null, both text boxes are empty and can shrink & Access will delete the blank line for you.




[This message has been edited by Chris RR (edited 04-06-2001).]