Zooming memo field in single form view

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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!
 
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!
Click to expand...
 
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.
 
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.
Click to expand...
 
Back
Top