Expanding Memo Field in Form

[AKQTS]

I am trying to accomplish the following:

In the form snippet above the last column on the right is a notes section where the user can record notes. This field is currently set-up as a memo field in the table the data resides in rich text format. On the form it is set-up as a list box. This is a continuous Form so i was trying to stay away from a subform.



What I would like to happen is when the user clicks on the "Notes" box for a specific row, the box either expands or opens in a new small window so they can enter or view the entire note.

As of right now they can enter text, but they have to right arrow throught the note to read it, basically a word at a time. Any help would be great, thanks.

[NoellaG]

Hi,

you could create a pop-up form with only the Notes field, and maybe a hidden ID field. Then set the "On dbl click" event of the notes field to open this pop-up form with the corresponding data.

grNG

[AKQTS]

That is what I was trying to do. I have created the form, I have created an "On-Click" macro for when the user clicks that field, it will open the form.

How do I make that new "Notes" form automatically (even through the macro if it can be done) select the correct record the user clicked on, I.E. that note for the part number and lot number of the row the user clicked on?

Right now it has them select an order and automatically populates just the first part on that order, not the one clicked on.

[AKQTS]

Just figured it out!