Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Complex Check boxes display on Report

Status
Not open for further replies.

jonmitch

IS-IT--Management
Oct 15, 2002
21
US
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. Can I do this with labels or do I need them to be text boxes?
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!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top