Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Applies to

BoundObjectFrame Object

Image Object

OptionButton Object

Section Object

CheckBox Object

Label Object

OptionGroup Object

SubForm Object

ComboBox Object

Line Object

Page Object

TabControl Collection

CommandButton Object

ListBox Object

Rectangle Object

TextBox Object

CustomControl Object

ObjectFrame Object

Report Object

ToggleButton Object

You can use the Height property (along with the Width property) to size an object to specific dimensions. Read/write Integer for all objects in the Applies To list except for the Report object, which is a read/write Long.

expression.Height

expression Required. An expression that returns one of the above objects.

&nbspRemarks

The Height property applies only to form and report sections, not to forms and reports.

Enter a number for the desired height in the current unit of measurement. To use a unit of measurement different from the setting in the Regional Options dialog box in Windows Control Panel, specify the unit, such as cm or in (for example, 5 cm or 3 in).

You can set this property by using the object's property sheet, a macro, or Visual Basic for Applications (VBA) code.

For controls, you can set the default for this property by using the default control style or the DefaultControl property in VBA code.

In VBA, use a numeric expression to set the value of this property. Values are expressed in twips.

For report sections, you can't use a macro or VBA code to set the Height property when you print or preview a report. For report controls, you can set the Height property when you print or preview a report only by using a macro or an event procedure specified in a section's OnFormat event property setting.

You can't set this propery for an object once the print process has started. For example, attempting to set the Height property in a report's Print event generates an error.

Microsoft Office Access 2007 automatically sets the Height property when you create or size a control or when you size a window in form Design View or report Design view.

The height of sections is measured from the inside of their borders. The height of controls is measured from the center of their borders so controls with different border widths align correctly. The margins for forms and reports are set by clicking Margins on the Page Layout tab.

Note: To set the left and top location of an object, use the Left and Top properties.

Example

The following code resizes a command button to a 1-inch by 1-inch square button (the default unit of measurement in VBA is twips; 1440 twips equals one inch):

Me!cmdSizeButton.Height = 1440    ' 1440 twips = 1 inch.
Me!cmdSizeButton.Width = 1440

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×