I am in the process of designing a form and I wish someone can answer the following issues for me:

1. How to get around the 22'' max height of the access form? It seems the only way is to create multiple columns, but a form with more than 2 columns are inconvenient (i.e. the data inputer has to scroll over a lot...).

2. When I set the MultiSelect property on a list box, how do I get all the highlighted values from that box to show up (i.e. be stored) in my table?? For instance if the listbox contains "apple, oranges, banana" and I highlight all three, then I would like "apple, oranges, banana" to show up as values in a field of my table.

Thank you and I'd appreciate any help on this.