Can Grow, Can Shrink on a Form

[PeterM]

I have a small form where I display errors and warning messages based on
edits to the form. The form can have from 1 to as many as 20 messages to
display. I've setup the form as a continuous view so the user can scroll
up/down to see all of the messages. The last field on the form is the
error/warning message text. It is setup as a text box. I have CanGrow = yes
and CanShrink=yes on the textbox, the details section and the header section
but the text box will not display all of the message for long messages. I
don't understand. I use CanGrow/Shrink all over the place on reports and it
works great. Does it work differently on a form? I've searched this forum
and google and cannot find my situation described.

The continuous form has the following controls;
MessageType [either "Error" or "Warning"]
MessageNumber [if available]
MessageItem [the control in error]
MessageText [the full text of the message]

Only the MessageText is setup as CanGrow/Shrink = yes. I've tried making
them all CanGrow/Shrink = yes and it made no difference. I open the form:

DoCmd.OpenForm "ErrorsWarnings", acNormal, , , acFormReadOnly, acWindowNormal


Any advice is appreciated.

 

[Jeff Boyce]

Peter

The following is from the MSDN site ... is either the case in your
situation?

a.. The CanGrow property does not apply to a form or report page header
and page footer sections, although it does apply to controls in such
sections.

b.. This property affects the display of form sections and controls only
when the form is printed or previewed, not when the form is displayed in
Form view, Datasheet view, or Design view.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[PeterM]

Jeff...

Thanks for the info. Item b applies and that pretty much answers my
question. It can't be done in continuous form display.

Peter

The following is from the MSDN site ... is either the case in your
situation?

a.. The CanGrow property does not apply to a form or report page header
and page footer sections, although it does apply to controls in such
sections.

b.. This property affects the display of form sections and controls only
when the form is printed or previewed, not when the form is displayed in
Form view, Datasheet view, or Design view.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

I have a small form where I display errors and warning messages based on
edits to the form. The form can have from 1 to as many as 20 messages to
display. I've setup the form as a continuous view so the user can scroll
up/down to see all of the messages. The last field on the form is the
error/warning message text. It is setup as a text box. I have CanGrow =
yes
and CanShrink=yes on the textbox, the details section and the header
section
but the text box will not display all of the message for long messages. I
don't understand. I use CanGrow/Shrink all over the place on reports and
it
works great. Does it work differently on a form? I've searched this
forum
and google and cannot find my situation described.

The continuous form has the following controls;
MessageType [either "Error" or "Warning"]
MessageNumber [if available]
MessageItem [the control in error]
MessageText [the full text of the message]

Only the MessageText is setup as CanGrow/Shrink = yes. I've tried making
them all CanGrow/Shrink = yes and it made no difference. I open the form:

DoCmd.OpenForm "ErrorsWarnings", acNormal, , , acFormReadOnly,
acWindowNormal


Any advice is appreciated.

.

 

[Peter Hibbs]

Peter,

You could do it by using a Flex Grid ActiveX control instead of the
Continuous form, see this site for an example of what you are trying
to do :-

http://www.rogersaccesslibrary.com/...576a14a9-c54c-4e39747f-bz327c8b-23bbz48f.html

Whether you would want to go to that much trouble is another matter,
of course.

Peter Hibbs.

Jeff...

Thanks for the info. Item b applies and that pretty much answers my
question. It can't be done in continuous form display.

Peter

The following is from the MSDN site ... is either the case in your
situation?

a.. The CanGrow property does not apply to a form or report page header
and page footer sections, although it does apply to controls in such
sections.

b.. This property affects the display of form sections and controls only
when the form is printed or previewed, not when the form is displayed in
Form view, Datasheet view, or Design view.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

I have a small form where I display errors and warning messages based on
edits to the form. The form can have from 1 to as many as 20 messages to
display. I've setup the form as a continuous view so the user can scroll
up/down to see all of the messages. The last field on the form is the
error/warning message text. It is setup as a text box. I have CanGrow =
yes
and CanShrink=yes on the textbox, the details section and the header
section
but the text box will not display all of the message for long messages. I
don't understand. I use CanGrow/Shrink all over the place on reports and
it
works great. Does it work differently on a form? I've searched this
forum
and google and cannot find my situation described.

The continuous form has the following controls;
MessageType [either "Error" or "Warning"]
MessageNumber [if available]
MessageItem [the control in error]
MessageText [the full text of the message]

Only the MessageText is setup as CanGrow/Shrink = yes. I've tried making
them all CanGrow/Shrink = yes and it made no difference. I open the form:

DoCmd.OpenForm "ErrorsWarnings", acNormal, , , acFormReadOnly,
acWindowNormal


Any advice is appreciated.

.