Displaying MEMO fields

[Fendi Baba]

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..

[Rick Brandt]

Fendi Baba wrote:

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..

You could use a single form view for the subform or a continuous form view.
In either case you can then make the TextBox whatever size you want. You
can also just make the rows taller in your current datasheet by just
dragging the bottom edge with your mouse. As soon as it is more than one
line tall then the text will wrap with a vertical scrollbar instead of
scrolling off to the right.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[cmd]

I use a macro attached to the memo field's double-click event. The
macro consists of a SendKeys action with the following typed into the
Keystrokes box:
+({F2})

The Wait box is set as "Yes"

(on the form, I have a reminder to the user to double-click to "zoom").

Hope this helps,
Mark

[Rick Brandt]

cm*@mountain.net wrote:

I use a macro attached to the memo field's double-click event. The
macro consists of a SendKeys action with the following typed into the
Keystrokes box:
+({F2})

The Wait box is set as "Yes"

(on the form, I have a reminder to the user to double-click to
"zoom").

Hope this helps,
Mark

Ugh. No need for SendKeys. There is a command for the ZoomBox...

DoCmd.RunCommand acCmdZoomBox

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Fendi Baba]

Thanks for both suggestion. At the moment, I am inclined to design the
subform using a continous form view.