I am designing a simple application which has school records in one
table. In a related table, I store school's comments, which essentially
are feedback gathered about the school. This table has a memo field
which stores the actual feedback.

To display the data, I created a form, with a subform containing the
feedbacks, I displayed the feedback using datagrid. This is of course
not ideal, The memo field content are displayed in a single row, Users
would have to scroll to the right to view the content. What are the
alternative that I have to display the content. Perhaps, I could click
on the row and a pop up box display the memo field? I am new to access.
I wonder what experienced access designer do to overcome this.

Thanks for your thoughts and comments..