Popup a Memo field to add more data

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I have a memo field on a continuous form. But I have it in a small rectangle
on the form. How can I click on the memo box and have it pop-out so I can
add more data? Is this possible?

Thanks

Ben
 
Ben said:
I have a memo field on a continuous form. But I have it in a small
rectangle
on the form. How can I click on the memo box and have it pop-out so I can
add more data? Is this possible?

Thanks

Ben
Click to expand...

Yes build a really nice big form with a really big huge memo text box that
nearly fills the whole screen. Base this form on the SAME table as the
coutines form.

then in the click event code of the memo text box on the continuous form you
simply go:

if me.Dirty = true then
me.dirty = false
end if

docmd.OpenForm "myFromWithReallyBigTextBox",,,"id = " & me!id

In the above piece of sample code I assumed that your primary key of a
continuous form has a field called "id". if you do something different than
the default of ID, then simply change the above code to reflect this.
 
Albert,
When I create the text box, do I assign it to the field or just not assign
it to anything?
 
Ben said:
Albert,
When I create the text box, do I assign it to the field or just not assign
it to anything?
Click to expand...

You simply build a new form based on that same underlying table, and yes the
text box is bound to that memo field. You can even use the wizard to create
the initial form, but you really only need the memo field display on this
form, and you want to resize it as large as possible.

You should in the forms property sheet (the other tab). make this form
model. This will "force" the user to close this form when done. (you don't
want a situation where the person doesn't close this memo form, and then
goes back and starts navigating in the continuous form, as that will mess
things up and that person will now be on a different record ).

So make the form based on the same underlying table. Simply place the one
control that is bound to the memo text box field on that form and re-size it
really large. You can also check and ensure that the enter key settings on
the other tab of the property sheet for that control box are set to make a
new line in the field as opposed to trying to move to the next textbook
control a form which you don't have . This will allow the user to hit the
enter key to enter new lines of text into that text box.

You might as well also set the form's additions property to no. Turn off the
navigation options on the boottom of the screen. You might as well turn off
the record selector button. So, spend some time turning off most of the
forms junk that you don't need.

You want a nice big clean form with a big text box to edit the memo...
 
In the textbox's DoubleClick event,
RunCommand acCmdZoomBox
will open the same zoom box you get by pressing <Shift><F2>. I do that for
every textbox that contains note-type free text fields.
 
Back
Top