Forms datasheet mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that I open within a form in datasheet mode. Within this form
is a memo field. It occupies a small amount of 'typeable' space.

When this field gains the focus, is it possible to expand the memo field so
that more text can be entered easily whilst seeing all the text entered.
 
I have a table that I open within a form in datasheet mode. Within this form
is a memo field. It occupies a small amount of 'typeable' space.

When this field gains the focus, is it possible to expand the memo field so
that more text can be entered easily whilst seeing all the text entered.
Click to expand...

No .... and Yes.

You cannot have individual fields of differing heights.
However, you can either make them all taller by setting the Height
property (format + Row Height) of the controls while in Form Datasheet
View, or coding the Control's Enter event to open a Zoom Box:

DoCmd.RunCommand acCmdZoomBox
 
fredg said:
No .... and Yes.

You cannot have individual fields of differing heights.
However, you can either make them all taller by setting the Height
property (format + Row Height) of the controls while in Form Datasheet
View, or coding the Control's Enter event to open a Zoom Box:

DoCmd.RunCommand acCmdZoomBox
Click to expand...

And, of course, you can open the zoom box manually by pressing Shift+F2
while the control has the focus.
 
thanks, did teh trick



is it possible to change the caption of the zoom box (the title)????
 
Patrick Stubbin said:
thanks, did teh trick



is it possible to change the caption of the zoom box (the title)????
Click to expand...

Not as far as I know. If you need to do that, you'll have to replicate
the functionality using your own popup form containing a big text box.
 
Back
Top