I have a combo box in my report design and I would like it to display "true" values as a list with check boxes![]()
I have a combo box in my report design and I would like it to display "true" values as a list with check boxes![]()
Why? Reports are not intended to be interactive. Report in print preview certainly is not. The combobox list will not display in paper printout.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
No I do not want it to be interactive, I would like it to display for ease of reading. Currently the box shows all the true values like this : Apples, Plums, Pears - I would like it to show (check) Apples etc.
Sorry, combobox will not display dropdown list on a report. Why is the check mark important? If the value shows in the box then it is checked.
I NEVER use multi-value fields.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I believe you should be using a sub report
I am not sure a subreport is needed. If you want the multiple items listed vertically, then the report RecordSource must be a query that expands the multiple values to individual records. https://support.office.com/en-us/art...3-B6624E1E323A
Then use report Sorting & Grouping features to organize the data.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.