We help IT Professionals succeed at work.

Memo box

Jass Saini
Jass Saini asked
on
147 Views
Last Modified: 2014-12-29
How do I get the Memo box to pop up when clicking on the field it is related to on the form??
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Add form with this field only and open it in on click event
Mike EghtebasDatabase and Application Developer

Commented:
You need to make a separate form to include the information you need to displayed when it opens.

In the click or dble-click event of the comment text box, you open this new form with OpenArgs = ID you have.

In the open argument of this form, bound to the same table, filter records by ID in OpanArgs.

You will have to text boxes on this form txtComment2 (unbound), and txtComment (bount but invisible). The comment box visible gets populated by:

txtComment2 = txtComment

Upon Cancel button (on this new form) you just close the form. But, upon click on Save button (again, on this new form) you save it in the table by:

txtComment = txtComment2

Also make sure to have me.refresh on the OnActive event of your original form.

Mike
CERTIFIED EXPERT
Top Expert 2016

Commented:
is this what you want? place this in the click or double click event of the textbox

docmd.RunCommand acCmdZoomBox

Author

Commented:
I want it to tie back to a record --the "remarks" field is apart of that record.
CERTIFIED EXPERT
Top Expert 2016
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you that worked
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Whether you go with the Access zoom box or create your own form, I would use the double-click event to initiate the action.  If you use the click event, you prevent people from ever editing data in the form, you always have to open the zoom box.  Also, I rarely use code to open the zoom box.  It is too valuable a tool and since I can't or don't want to add a double-click event to every text control on every form, I teach the users how to use Shift-F2.  That way, they can open the zoom box for ANY control on ANY form and I don't have to write code to manage it.

Author

Commented:
How do you change the Zoom box title...I would like it to say "Remarks" and not just Zoom...

Pat how would you do it then
CERTIFIED EXPERT
Top Expert 2016

Commented:
<I would like it to say "Remarks" and not just Zoom...>

you cannot.

the only way to do that is to create a form and open the form in the double click event of the textbox
with an openargs option.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.