Office Settings & Configuration

Fix Disabled Rows and Columns Options in Microsoft Access Forms

Tauseeq MagsiTauseeq Magsi Nov 22, 2026 868 views

Question details

The user wants to enable the Rows and Columns layout options for controls on an Access form.

Fix Disabled Rows and Columns Options in Microsoft Access Forms
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Design View

In the Navigation Pane, right-click the form and select Design View.

2
Select the controls

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.

3
Remove the layout

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.

4
Check the commands

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.

Remove the Existing Control Layout in Access Design View
Command availability: Removing a layout changes how the selected controls are arranged. If a command remains disabled, check that you are in Design View and have selected controls appropriate for that command.
Free Microsoft Office alternative

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.

Work with Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTX.Use a familiar interface for everyday document and spreadsheet tasks.Open existing Office files to support a smooth transition.Keep Microsoft Access for database forms and control layouts.
microsoft office alternative - wps office

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.