Fix Disabled Rows and Columns Options in Microsoft Access Forms
Question details
The user wants to enable the Rows and Columns layout options for controls on an Access form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Editing the position and layout of controls on an Access form.
- Observed behavior
- The Rows and Columns commands are disabled, and a dotted outline around multiple controls may indicate an active layout.
Open the database containing the form and identify the controls you want to change. Look for a dotted outline around multiple controls, which can indicate that they share a layout.
Remove the Existing Control Layout in Access Design View
Use this method when controls are part of a layout and you want to position or resize them independently.
In the Navigation Pane, right-click the form and select Design View.
Click a control in the layout, then select the other controls you want to change. Press Ctrl+A if you intend to select all controls on the form.
Right-click the selected controls and choose Remove Layout. Depending on your Access version, look under Layout in the shortcut menu or use Arrange > Remove Layout on the ribbon.
Select the controls you want to arrange and check the Rows and Columns options on the Arrange tab. You can also drag or resize the controls independently.

Use WPS Office for Everyday Office Files
WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations in a familiar interface. Its Microsoft Office format support helps you move existing files into your workflow. WPS Office does not edit Access databases or fix Access form layouts.

Frequently Asked Questions
How can I tell whether Access form controls share a layout?
Open the form in Design View and select a control. A dotted outline around multiple controls can indicate that they are in the same layout.
Where is Remove Layout in Access?
In Design View, select the controls and right-click to find Remove Layout. Depending on the Access version, it may appear under Layout in the shortcut menu or on the Arrange tab.
Will removing a layout delete my form controls?
No. Remove Layout separates the selected controls from the layout so you can move or resize them independently; it does not delete the controls.
Why are Rows and Columns still disabled after I remove the layout?
Check that the form is open in Design View and that you have selected controls appropriate for the command on the Arrange tab. Availability depends on the current selection and context.




