Zooming memo field in single form view

G

Guest

Yesterday someone asked how to "zoom" a memo field in datasheet view. I have
a similar problem in that I want to be able to automatically zoom a memo
field in single form view. We need all the data to fit on the form without
using scroll bars (don't ask why!!), but two memo fields often contain more
data than can be visualized without scrolling the field. Can I somehow force
those two fields to open a zoom box when they receive focus? I am using
Access 97, and the Help section doesn't indicate that a zoom box can be used
in single form view. I am not very familiar with code, so if the solution
needs code, i will need very explicit directions on how to do it. Thanks in
advance!
 
G

Guest

Thanks, Karl. This looks like what I need. The trouble with Access Help is
you need to know what to ask for..., and I never heard of popup forms before!
 
G

Guest

I find the HELP on the older Acces was better.

Susan said:
Thanks, Karl. This looks like what I need. The trouble with Access Help is
you need to know what to ask for..., and I never heard of popup forms before!
 
S

Stephen Lebans

In the GotFocus event for each of the TextBox controls bound to your
Memo fields call the following method:

DoCmd.RunCommand acCmdZoomBox

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
G

Guest

Thanks, Stephen...worked perfectly!

Stephen Lebans said:
In the GotFocus event for each of the TextBox controls bound to your
Memo fields call the following method:

DoCmd.RunCommand acCmdZoomBox

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

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

Top