Memo box

How do I get the Memo box to pop up when clicking on the field it is related to on the form??
Jass SainiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
Add form with this field only and open it in on click event
0
Mike EghtebasDatabase and Application DeveloperCommented:
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
0
Rey Obrero (Capricorn1)Commented:
is this what you want? place this in the click or double click event of the textbox

docmd.RunCommand acCmdZoomBox
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jass SainiAuthor Commented:
I want it to tie back to a record --the "remarks" field is apart of that record.
0
Rey Obrero (Capricorn1)Commented:
then this all you need

docmd.RunCommand acCmdZoomBox
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jass SainiAuthor Commented:
Thank you that worked
0
PatHartmanCommented:
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.
0
Jass SainiAuthor 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
0
Rey Obrero (Capricorn1)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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.