ComboBox.CanGrow 屬性 (Access)ComboBox.CanGrow property (Access)

取得或設定是否指定的控制項會自動調整垂直列印或預覽控制項包含的所有資料。Gets or sets whether the specified control automatically adjusts vertically to print or preview all the data that the control contains. 可讀寫的 BooleanRead/write Boolean.



_運算式_代表**ComboBox** 物件的變數。expression A variable that represents a ComboBox object.


CanGrow 屬性使用下列設定值。The CanGrow property uses the following settings.

設定Setting Visual BasicVisual Basic 描述Description
Yes True 是表示(1)True (1) 區段或控制項垂直增大,讓其中所包含的全部資料能被列印或預覽。The section or control grows vertically so that all data it contains can be printed or previewed.
No False (0)False (0) (預設值) 區段或控制項不會增大。(Default) The section or control doesn't grow. 不適合於固定尺寸之中區段或控制項的資料將無法被列印或預覽。Data that doesn't fit within the fixed size of the section or control won't be printed or previewed.

此屬性設定值在除了 [設計檢視] 外的其他檢視下,於巨集或 Visual Basic 中都是唯讀的。This property setting is read-only in a macro or Visual Basic in any view but Design view.

您可以使用該屬性來控制列印表單和報表的外觀。You can use this property to control the appearance of printed forms and reports. 當您將屬性設定為 [是] 時,物件會自動調整以使任何數量的資料可以列印。When you set the property to Yes, the object automatically adjusts so that any amount of data can be printed. 當控制項增大時,下面的控制項將移往資料頁之下方。When a control grows, the controls below it move down the page.

如果您將控制項的 CanGrow 屬性設定為 [是] 時,Microsoft Access 會自動設定為 [是] 控制項所包含之區段的 CanGrow 屬性。If you set a control's CanGrow property to Yes, Microsoft Access automatically sets the CanGrow property of the section containing the control to Yes.

章節垂直擴充跨他們的整個寬度。Sections grow vertically across their entire width. 若要單獨成長的資料,您可以將兩個子表單或子報表控制項並排顯示,並將其 CanGrow 屬性設定為 [是]。To grow the data independently, you can place two subform or subreport controls side by side, and set their CanGrow property to Yes.

當您使用 CanGrow 屬性時,請記得:When you use the CanGrow property, remember that:

  • 屬性設定不會影響控制項; 之間的水平間距它們會影響僅限控制項所佔有的垂直空間。The property settings don't affect the horizontal spacing between controls; they affect only the vertical space that the controls occupy.

  • 重疊的控制項不能調大。Overlapping controls can't grow.

支援和意見反應Support and feedback

有關於 Office VBA 或這份文件的問題或意見反應嗎?Have questions or feedback about Office VBA or this documentation? 如需取得支援服務並提供意見反應的相關指導,請參閱 Office VBA 支援與意見反應Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.