Forms datasheet mode

P

Patrick Stubbin

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.
 
F

fredg

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
 
D

Dirk Goldgar

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.
 
P

Patrick Stubbin

thanks, did teh trick



is it possible to change the caption of the zoom box (the title)????
 
D

Dirk Goldgar

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.
 
Top