Memo Fields

  • Thread starter Thread starter Maria
  • Start date Start date
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
 
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
 
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.
 
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
 
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
 
Back
Top