Memo Fields

M

Maria

I am using Access 2000

I have created a Db and a form (with 2 memo fields) to
enter information. The people using the form want to only
see the first few words in the Memo field on the form.
But they want to be able to click on the field and see the
whole thing and click again to go back to the form. Is
there a way to do this? Maybe with a hyperlink?????

Can anyone help me??

Maria
 
R

Rick Brandt

Maria said:
I am using Access 2000

I have created a Db and a form (with 2 memo fields) to
enter information. The people using the form want to only
see the first few words in the Memo field on the form.
But they want to be able to click on the field and see the
whole thing and click again to go back to the form. Is
there a way to do this? Maybe with a hyperlink?????

Can anyone help me??
Click to expand...

You could just make the TextBox as small as desired and then in the
Double-Click event invoke the built-in ZoomBox feature. Normally you could
bring it up with <Shift-F2>.

DoCmd.RunCommand acCmdZoomBox
 
J

John Vinson

The people using the form want to only
see the first few words in the Memo field on the form.
But they want to be able to click on the field and see the
whole thing and click again to go back to the form.
Click to expand...

If they focus on the field and press Alt-F2 it will "zoom" (open a
large text window).

You can put VBA code in the textbox's Doubleclick event (click is
probably too much of a hairtrigger) to zoom as well. Look up Zoom in
the VBA online help.
 
M

Maria

Thank you so much for replying. I have used that key
stroke many times when tring to see the calculation I was
creating. It just didn't dawn on me to use it here.
Again thank you very much. I would be lost with this
newsgroup.

Maria
 
M

Maria

I just want to say thank you. I have used this key
combination before when I was creating calculations in
forms but never thought to use it here. I would certainly
lost without the help of you and the others in the
newsgroup. THANK YOU!!

Maria
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MEMO Field cut off on Form 3
Form Keeps getting Corrupted 9
Memo Field Limits??? 5
Arranging text in a memo field 2
In MS Access 2003, How do I print Memo Fields to AutoExpand? 2
does FORMAT function cause issues with Memo fields? 3
sorting on memo fields via creation date or last update 1
memo field on the form-- text wrapped/ text unwrapped 1

Top