If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can Grow, Can Shrink on a Form
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. |
#2
|
|||
|
|||
Can Grow, Can Shrink on a Form
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" wrote in message ... 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. |
#3
|
|||
|
|||
Can Grow, Can Shrink on a Form
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" wrote in message ... 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. . |
#4
|
|||
|
|||
Can Grow, Can Shrink on a Form
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/f...-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 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" wrote in message ... 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. . |
Thread Tools | |
Display Modes | |
|
|