Can Grow setting on a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich J - 28 Jan 2005 23:19 GMT

I have a continuous subform in Access 97 that I want to grow on the main form
as entries are added. I set the Can Grow to Yes on both the subform itself
and embedded subform property where it is placed in the main form.
It works perfectly for the report that is generated but it would make
entering the data on the form easier for users. I'm sure it's something
simple I'm overlooking but couldn't find any similar situations listed here.
I tried removing the vertical scroll bar from the subform thinking that
might force it to grow but it showed only 3 1/2 records. I think I'm doing
the same thing as I did on the report / subreport properties but it's not
working the same for the form.
Thanks for any advice.
Rich J

Reply to this Message

Rick Brandt - 29 Jan 2005 00:22 GMT

>I have a continuous subform in Access 97 that I want to grow on the main form
> as entries are added. I set the Can Grow to Yes on both the subform itself
[quoted text clipped - 8 lines]
> Thanks for any advice.
> Rich J

Even on a form CanGrow only applies to *printing*. For what you want you would
need VBA code that resized the main form and the subform in addition to moving
anything that might be "under" the subform.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Rich J - 29 Jan 2005 01:17 GMT

I knew it had to be something simple. Now I'll have to figure out code to
count the number of records generated in the subform and resize it each time.
I'll probably be back here with a posting for that when I hit a snag. Or I
could just let them use the scroll bar I guess. Thanks Rick.

Rich J

> >I have a continuous subform in Access 97 that I want to grow on the main form
> > as entries are added. I set the Can Grow to Yes on both the subform itself
[quoted text clipped - 12 lines]
> need VBA code that resized the main form and the subform in addition to moving
> anything that might be "under" the subform.

Reply to this Message

John Vinson - 29 Jan 2005 01:28 GMT

>I have a continuous subform in Access 97 that I want to grow on the main form
>as entries are added. I set the Can Grow to Yes on both the subform itself
>and embedded subform property where it is placed in the main form.

The Can Grow property of a Form applies only when you're *printing*
the form - not when you're just displaying it, unfortunately!

If you have the tab key behavior set up correctly, it should scroll to
the next record (making it visible and scrolling previous records up
offscreen) when you finish the current record. It sounds like a user
training issue more than anything else; unless you have a 22" high
monitor you'll end up going off the screen anyway!

John W. Vinson[MVP]

Reply to this Message

Rich J - 29 Jan 2005 01:53 GMT

The Cycle Property is set to All Records. 4 records is currently what fits
in the subform box as sized. When I finish adding the fourth record, I still
have to use the scroll bar or mouse wheel to view the new blank record that
is generated. If the subform scrolled up as data was added that would be
great. The report for printing works fine thus far.

> >I have a continuous subform in Access 97 that I want to grow on the main form
> >as entries are added. I set the Can Grow to Yes on both the subform itself
[quoted text clipped - 10 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 29 Jan 2005 02:32 GMT

>The Cycle Property is set to All Records. 4 records is currently what fits
>in the subform box as sized. When I finish adding the fourth record, I still
>have to use the scroll bar or mouse wheel to view the new blank record that
>is generated. If the subform scrolled up as data was added that would be
>great. The report for printing works fine thus far.

Try making the subform a tiny bit *SMALLER*. I suspect that the top
edge of the fifth record is just barely visible; if it's not visible
at all, it SHOULD scroll up.

John W. Vinson[MVP]

Reply to this Message