By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,226 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

Datasheet Form Not Growing to Show Data

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
-----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 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQfqs8IechKqOuFEgEQIyzgCfcOcaiPg3LohuHe4GQpYx71 n19y0AoO/V
U6vrLaTWl8YWIaz7Ap+/Ap3X
=K8R9
-----END PGP SIGNATURE-----
ko*******@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?

Nov 13 '05 #2

P: n/a
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...

Nov 13 '05 #3

P: n/a
-----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 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQf77tYechKqOuFEgEQJ2zQCeI2jrfanAqvsofA0MqqnCHJ 208icAoKac
D+aWtS795pyjGJxrz2QXw4lL
=j78+
-----END PGP SIGNATURE-----
ko*******@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...

Nov 13 '05 #4

P: n/a
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.

Nov 13 '05 #5

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQf/kLoechKqOuFEgEQKH1QCg6SV9Xewssk7UibP03fh0BQ8rjokAn 3d1
Ir+8cAqR1cZUT3bL2lwjlvtC
=WG44
-----END PGP SIGNATURE-----
ko*******@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.

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.