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.
|
|
0
|
|
|
|
Reply
|
Utf
|
4/19/2010 10:47:01 PM |
|
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" <PeterM@discussions.microsoft.com> wrote in message
news:24B634A3-50E8-47A7-89FB-8BBBBC915303@microsoft.com...
>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.
|
|
0
|
|
|
|
Reply
|
Jeff
|
4/19/2010 11:13:13 PM
|
|
Jeff...
Thanks for the info. Item b applies and that pretty much answers my
question. It can't be done in continuous form display.
"Jeff Boyce" wrote:
> 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" <PeterM@discussions.microsoft.com> wrote in message
> news:24B634A3-50E8-47A7-89FB-8BBBBC915303@microsoft.com...
> >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.
>
>
> .
>
|
|
0
|
|
|
|
Reply
|
Utf
|
4/20/2010 12:03:01 AM
|
|
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/forum/flex-grid-demo_topic511&SID=576a14a9-c54c-4e39747f-bz327c8b-23bbz48f.html
Whether you would want to go to that much trouble is another matter,
of course.
Peter Hibbs.
On Mon, 19 Apr 2010 17:03:01 -0700, PeterM
<PeterM@discussions.microsoft.com> wrote:
>Jeff...
>
>Thanks for the info. Item b applies and that pretty much answers my
>question. It can't be done in continuous form display.
>
>"Jeff Boyce" wrote:
>
>> 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" <PeterM@discussions.microsoft.com> wrote in message
>> news:24B634A3-50E8-47A7-89FB-8BBBBC915303@microsoft.com...
>> >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.
>>
>>
>> .
>>
|
|
0
|
|
|
|
Reply
|
Peter
|
4/20/2010 8:46:03 AM
|
|
|
3 Replies
1755 Views
(page loaded in 0.051 seconds)
Similiar Articles: Can Grow, Can Shrink on a Form - microsoft.public.access ...Can Grow/Can Shrink Question.... I think! - microsoft.public ... Can Grow and Can Shrink Question DataBase Why does the Can Grow and Can Shrink properties of a text ... Text Box Can Grow Property - microsoft.public.access.reports ...Can Grow, Can Shrink on a Form - microsoft.public.access ... Selecting "yes" for "can grow" or "can shrink" for the text box properties ... > sample to control the ... Can Grow/Can Shrink Question.... I think! - microsoft.public ...Can Grow/Can Shrink Question.... I think! - microsoft.public ... Can Grow and Can Shrink Question in Access Forms Coding Why does the Can Grow and Can Shrink ... Load Switchboard Maximum - microsoft.public.access.forms ...... Visible Display When Can grow Can Shrink Height ... microsoft.public.access.forms ... I have a form called Switchboard. I have it to load ... When Can grow Can Shrink Height ... can grow / can shrink , control position conflict - microsoft ...Get Rid of Left Margin ... can grow / can shrink ... conflict - microsoft ... fixed form size - microsoft.public.access I have treid the Can grow and Can shrink ... Can Grow not working? - microsoft.public.access.reports ...Can Grow, Can Shrink on a Form - microsoft.public.access ... Can Grow and Can Shrink Question DataBase Why does the Can Grow and Can Shrink properties of a text field on a ... How to a bound textbox on a form grow - microsoft.public.access ...Can Grow, Can Shrink on a Form - microsoft.public.access ... How to a bound textbox on a form grow - microsoft.public.access ... Can Grow, Can Shrink on a Form - microsoft ... Make a text box fit the value inside - microsoft.public.access ...Selecting "yes" for "can grow" or "can shrink" for the text box properties does not make a ... sample to control the horizontal size of a control in a report or a form. Problems with can grow fields on data report - vb6 - microsoft ...Shifting fields up in the form if data is not present - microsoft ... Problems with can grow fields on data ... Can Shrink and Can Grow ... Visual Basic :: Change The Field ... How do I change the height of individual rows in Access 2007 ...In tables or queries, pretty much so. You do have "Can Grow" and "Can Shrink" options in reports and forms. -- Jerry Whittle, Microsoft Access MVP Light. Can Grow, Can Shrink on a Form DataBase - DataBase Discussion List ...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 Can Grow and Can Shrink Question DataBaseWhy does the Can Grow and Can Shrink properties of a text field on a form not work, I have tried this on a report and it works fine but not on my input Can Grow, Can Shrink on a Form - microsoft.public.access ...Can Grow/Can Shrink Question.... I think! - microsoft.public ... Can Grow and Can Shrink Question DataBase Why does the Can Grow and Can Shrink properties of a text ... Make a text box grow or shrink to fit data when printing a form or ...Make a text box grow or shrink to fit data when printing a form or report. Applies to: Microsoft Office Access 2003 Can Grow/Can Shrink - Microsoft Access / VBAAccess2000 I have a subform control on a main form (it's the only control on the form except for a Close button on the bottom). The subform control contains a 7/21/2012 5:50:56 PM
|