I have a report that is pulled from a Query and in that query, among other things are 9 YES/NO fields that come over as check boxes. On the report I arranged them as follows:
These 4 are arranged below each other on the left:
Label38 then RFSBankruptcy (that is the name of the check box and the Control Source)
Label40 then RFSIndustryIssues (name and control source)
Label42 then RFSLiquidityIssues (same)
Label44 then RFSOperationalIssues (same)
These 5 alligned below each other on the right:
Label39 then RFSGeneralEconomy (same)
Label41 then RFSLenderIssues (same)
Label43 then RFSManagementProblems (same)
Label45 then RFSPoorAcquisitions (same)
Label46 then RFSOther (same)
Here is what I need:
1) I don't want any of the check boxes visible
2) I only want those labels Visible where there is a check, meaning a Yes value from the table.
3) Then I also want the spacing to automatically adjust. For example if the person check RFSBankruptcy and RFS Other, on the form you would have a label high to the left and low to the right with nothing in betweem.
Does anyone know the proper way to do all the things above?
Any help would be greatly appreciated!!!
These 4 are arranged below each other on the left:
Label38 then RFSBankruptcy (that is the name of the check box and the Control Source)
Label40 then RFSIndustryIssues (name and control source)
Label42 then RFSLiquidityIssues (same)
Label44 then RFSOperationalIssues (same)
These 5 alligned below each other on the right:
Label39 then RFSGeneralEconomy (same)
Label41 then RFSLenderIssues (same)
Label43 then RFSManagementProblems (same)
Label45 then RFSPoorAcquisitions (same)
Label46 then RFSOther (same)
Here is what I need:
1) I don't want any of the check boxes visible
2) I only want those labels Visible where there is a check, meaning a Yes value from the table.
3) Then I also want the spacing to automatically adjust. For example if the person check RFSBankruptcy and RFS Other, on the form you would have a label high to the left and low to the right with nothing in betweem.
Does anyone know the proper way to do all the things above?
Any help would be greatly appreciated!!!