Can datasheet row automatically grow / expand?

[Lynx101]

Hi, hope anyone can help with this query.

Background:
Subform datasheet link to a form to store updates on projects.

Query:
I have a datasheet where one of the field is a memo field. When text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
changes all the rows. Can anyone advise the best way to present the
data.

Thanks for your help.
Matt

[salad]

Lynx101 wrote:

Hi, hope anyone can help with this query.

Background:
Subform datasheet link to a form to store updates on projects.

Query:
I have a datasheet where one of the field is a memo field. When text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
changes all the rows. Can anyone advise the best way to present the
data.

Thanks for your help.
Matt

You could press the Shift+F2 key combination.

[fredg]

On 20 Apr 2007 14:13:11 -0700, Lynx101 wrote:

Hi, hope anyone can help with this query.

Background:
Subform datasheet link to a form to store updates on projects.

Query:
I have a datasheet where one of the field is a memo field. When text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
changes all the rows. Can anyone advise the best way to present the
data.

Thanks for your help.
Matt

The best way to present the data is in a report. That's what reports
are for. In a report, you can set the Memo control's Can Grow
property, as well as the Detail Section's Can Grow property, to Yes.

You don't state whether you're looking at a Table Datasheet or a Form
in Datasheet View.
Regardless, the only way to show all the data would be to manually
re-size the row. Even if you used a Form in Single or Continuous View,
the form control's Can Grow property only works if the form is
printed, not just viewed.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Tom van Stiphout]

On 20 Apr 2007 14:13:11 -0700, Lynx101 <ma**********@gmail.comwrote:

No. The datasheet row height is the same for all rows. If you REALLY
need variable height, you have to use a custom control. I once used
Infragistics' GridView control for just that reason (in VB6).

-Tom.

>Hi, hope anyone can help with this query.

Background:
Subform datasheet link to a form to store updates on projects.

Query:
I have a datasheet where one of the field is a memo field. When text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
changes all the rows. Can anyone advise the best way to present the
data.

Thanks for your help.
Matt

[Tom van Stiphout]

On Sat, 21 Apr 2007 00:45:42 GMT, salad <oi*@vinegar.comwrote:

A nice solution, but it's beyond me why MSFT after all these years
still hasn't gotten around to making this form resizeable.

-Tom.

>Lynx101 wrote:

>Hi, hope anyone can help with this query.

Background:
Subform datasheet link to a form to store updates on projects.

Query:
I have a datasheet where one of the field is a memo field. When text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
changes all the rows. Can anyone advise the best way to present the
data.

Thanks for your help.
Matt

You could press the Shift+F2 key combination.

[Lynx101]

Thanks for all your replies, i appreciate it. Whilst a report would
expand the fields automatically and would certainly do the job, I
need to use the datasheet to input data. At the moment I have manually
set the row height so that you can see a couple of lines. Does anyone
have a custom control to auto expand individual rows (not all rows)
according to how much data is entered into the field?

Thanks
Matt

[Chuck]

On 21 Apr 2007 02:14:14 -0700, Lynx101 <ma**********@gmail.comwrote:

>Thanks for all your replies, i appreciate it. Whilst a report would
expand the fields automatically and would certainly do the job, I
need to use the datasheet to input data. At the moment I have manually
set the row height so that you can see a couple of lines. Does anyone
have a custom control to auto expand individual rows (not all rows)
according to how much data is entered into the field?

Thanks
Matt

"need to use datasheet to input data"
Don't use the datasheet view of your table to view/edit/input data. Do it with
a form, then you can make the TextBox control for the memo field any size you
want. The form does not have to show all the fields in the table, only the
fields required to be sure that you are working with the correct record.

Chuck
--

[salad]

Chuck wrote:

On 21 Apr 2007 02:14:14 -0700, Lynx101 <ma**********@gmail.comwrote:

>>Thanks for all your replies, i appreciate it. Whilst a report would
expand the fields automatically and would certainly do the job, I
need to use the datasheet to input data. At the moment I have manually
set the row height so that you can see a couple of lines. Does anyone
have a custom control to auto expand individual rows (not all rows)
according to how much data is entered into the field?

Thanks
Matt

"need to use datasheet to input data"
Don't use the datasheet view of your table to view/edit/input data. Do it with
a form, then you can make the TextBox control for the memo field any size you
want. The form does not have to show all the fields in the table, only the
fields required to be sure that you are working with the correct record.

Chuck

If he used a form, he could put in a Dbl-Click event a call to open a
form to display the memo for editting.

The Shift+F2 combination, is like Tom said, not resizable. It's
probably something few have asked for or something MS doesn't consider
worth the time and effort to better.

[Susie DBA [MSFT]]

yeah.. it's called 'use a report'


On Apr 20, 2:13 pm, Lynx101 <[e-mail]:

Hi, hope anyone can help with this query.

Background:
Subform datasheet link to a form to store updates on projects.

Query:
I have a datasheet where one of the field is a memo field. When text
is entered the datasheet does not automatically expand to show all the
text. Is this possible? Obviously, some rows may have 2 lines of text
and some may have 10. I can manually expand the row height but that
changes all the rows. Can anyone advise the best way to present the
data.

Thanks for your help.
Matt