By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,394 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

Displaying MEMO fields

P: n/a
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..

Jan 17 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Jan 17 '06 #2

P: n/a
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

Jan 17 '06 #3

P: n/a
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
Jan 18 '06 #4

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

Jan 19 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.