Can Grow setting on a subform

[Guest]

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

 

[Rick Brandt]

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

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.

 

[Guest]

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

 

[John Vinson]

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]

 

[Guest]

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.

 

[John Vinson]

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]