Datasheet Form Not Growing to Show Data

A report has a subform. The subform is set to datasheet view and its
RecordSource is a select query that includes a memo field from the
source table. The memo field's Can Grow property is Yes, and the
subform Detail section's Can Grow property is Yes. The report Detail
section's Can Grow property is also Yes.

When run, the select query's memo field has all the data. However,
when I run the report, the subform does not show all the data in the
memo field. (I can open the suborm separately from the report and
scroll through the memo field to confirm all the data is there.)

I want to be able to have the subform, in datasheet view, to grow so
that it shows all the data in the memo field without me having to
statically assigning the row height. I thought the Can Grow property
would do that. Any suggestions?

Re: Datasheet Form Not Growing to Show Data

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Have you tried setting the subform control's CanGrow/Shrink properties
to Yes? This will allow the subform/subreport control to expand as the
Memo TextBox expands.

I'm not sure a datasheet is the best format for CanGrow/Shrink. Perhaps
you can user a regular form design, but put the controls in rows like a
datasheet.

--
MGFoster:::mgf00 earthlink net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQfqs8IechKqOuFEgEQIyzgCfcOcaiPg3LohuHe4GQpYx71n19y0A oO/V
U6vrLaTWl8YWIaz7Ap+/Ap3X
=K8R9
-----END PGP SIGNATURE-----


kotowskil@saic.com wrote:
> A report has a subform. The subform is set to datasheet view and its
> RecordSource is a select query that includes a memo field from the
> source table. The memo field's Can Grow property is Yes, and the
> subform Detail section's Can Grow property is Yes. The report Detail
> section's Can Grow property is also Yes.
>
> When run, the select query's memo field has all the data. However,
> when I run the report, the subform does not show all the data in the
> memo field. (I can open the suborm separately from the report and
> scroll through the memo field to confirm all the data is there.)
>
> I want to be able to have the subform, in datasheet view, to grow so
> that it shows all the data in the memo field without me having to
> statically assigning the row height. I thought the Can Grow property
> would do that. Any suggestions?
>

Re: Datasheet Form Not Growing to Show Data

Yes, I set the subform memo field properties, Can Grow and Can Shrink,
to "Yes." Did the same for the subform Detail section and the report
Detail section.

Before abandoning the datasheet view, I wanted to check with users
about possible solutions. I've experimented with setting the subform
Default View to Continuous Forms, but the other fields in the subform
do not grow to the same size as the one memo field.
Still seeking suggestions...

Re: Datasheet Form Not Growing to Show Data

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You're missing what I said in my last post: The subform/subreport is a
CONTROL on the main report that holds a subform/report. That control
also has CanGrow and CanShrink properties. Try setting both of those to
Yes.

If you have Access 2000, or greater, sometimes it is hard to set focus
on the subreport control in design view. Just make sure the subreport
control has the focus & not the subreport, itself. You'll know the
subreport HAS the focus when the subreport's "got focus" box has a black
square in it. That "got focus" box is located in the upper-left corner
of the subreport. Just click on the subreport control until the
subreport is outlined in a darker border. (Kinda hard to explain - you
really have to see it.)

--
MGFoster:::mgf00 earthlink net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQf77tYechKqOuFEgEQJ2zQCeI2jrfanAqvsofA0MqqnCHJ208icA oKac
D+aWtS795pyjGJxrz2QXw4lL
=j78+
-----END PGP SIGNATURE-----


kotowskil@saic.com wrote:
> Yes, I set the subform memo field properties, Can Grow and Can Shrink,
> to "Yes." Did the same for the subform Detail section and the report
> Detail section.
>
> Before abandoning the datasheet view, I wanted to check with users
> about possible solutions. I've experimented with setting the subform
> Default View to Continuous Forms, but the other fields in the subform
> do not grow to the same size as the one memo field.
> Still seeking suggestions...
>

Re: Datasheet Form Not Growing to Show Data

Thanks for clarifying. I sorta did miss your point... but I do
understand what you mean. In addition to what I have already
described, here's what I had also done for checking the Can Grow and
Can Shrink properties wherever I could find them within the main
report, subform/subreport control, or the subform/subreport itself:
(1) Selected the subform/subreport control within the main report by
right clicking the control so that the black-box handles appeared
around the subform and then I selected the properties. The
subform/subreport control already has the Can Grow and Can Shrink
properties set to Yes.
(2) Put the focus on the subform (so the black box appeared in the top
left of the subform) -- there are no properties for Can Grow or Can
Shrink. But I'm sure you probably know that.

I'm using Access 2002. I've searched MSDN knowledgebase, and I've not
found anything that describes how to deal with this situation.

Re: Datasheet Form Not Growing to Show Data

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Unfortunately, I've come to the end of my knowledge about subreports &
grow/shrink Memo controls.

--
MGFoster:::mgf00 earthlink net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQf/kLoechKqOuFEgEQKH1QCg6SV9Xewssk7UibP03fh0BQ8rjokA n3d1
Ir+8cAqR1cZUT3bL2lwjlvtC
=WG44
-----END PGP SIGNATURE-----


kotowskil@saic.com wrote:
> Thanks for clarifying. I sorta did miss your point... but I do
> understand what you mean. In addition to what I have already
> described, here's what I had also done for checking the Can Grow and
> Can Shrink properties wherever I could find them within the main
> report, subform/subreport control, or the subform/subreport itself:
> (1) Selected the subform/subreport control within the main report by
> right clicking the control so that the black-box handles appeared
> around the subform and then I selected the properties. The
> subform/subreport control already has the Can Grow and Can Shrink
> properties set to Yes.
> (2) Put the focus on the subform (so the black box appeared in the top
> left of the subform) -- there are no properties for Can Grow or Can
> Shrink. But I'm sure you probably know that.
>
> I'm using Access 2002. I've searched MSDN knowledgebase, and I've not
> found anything that describes how to deal with this situation.
>