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.