I want to have an MS Access 2007 combo box that has a listing of departments and a boolean field displaying a check box where a user can select multiple depts before viewing a report?
I don't believe the current MS Access 2007 allows me to do this within its current combo box because when I see the multiple records showing the boolean field it shows -1 or 0.
Is there a way I could fake this to the user with the current Access 2007 controls that is provided? I seen capricorn1, do cool things like put a text box over a combo box where it looks like its displaying multiple fields together as one format. Is there a way to do so with a list box over the combo box and increase the height size of the list box once selected?
If a listbox doesn't work perhaps overlay a subform that has a really small datagrid form over the combo box?
Could I get a sample of how this would be possible?5
Or do I have to create an MS Access control combo box and then references that in via a .dll? If the only way to do this is create my own MS Access 2007 control - is there a reference where I can do this?