Formatting Issues

Change the Width of One Field in a Microsoft Access Form

Amos GikundaAmos Gikunda Nov 14, 2026 868 views

Question details

Change the width of one control in an Access form or report without resizing other controls.

Change the Width of One Field in a Microsoft Access Form
Product
Microsoft Access
Device & OS
not provided
Scenario
A user wants to resize an individual field control in a form or report.
Observed behavior
Changing the width of one control also changes the width of other controls because they share a layout.
Before you start

Open the database containing the form or report and identify the control you want to resize. Removing it from the shared layout lets you adjust it independently.

Solution 1Recommended

Remove the Control from the Layout and Resize It

Use this method when a shared layout causes other controls to resize along with the selected field.

1
Open Design view

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

2
Select the control

Click the field control whose width you want to change. Make sure you select the control rather than its label.

3
Remove the layout

On the Arrange tab, select Remove Layout to detach the selected control from the shared layout.

4
Adjust the width

Drag a side sizing handle on the selected control to the desired width, then save the form or report.

Remove the Control from the Layout and Resize It
Check the arrangement: After removing the control from the layout, check its position and spacing relative to the other controls.
Free Microsoft Office alternative

Work with Office Documents in WPS Office

WPS Office is a free, lightweight alternative for documents, spreadsheets, and presentations, with a familiar interface and compatibility that makes moving from Microsoft Office easier. It does not replace Microsoft Access or edit Access form layouts.

A familiar interface for everyday Office tasksCompatibility with Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXTools for formatting document fields and spreadsheet dataA lightweight, free option for common office work
microsoft office alternative - wps office

Frequently Asked Questions

Why do other fields resize when I change one field in Access?

The controls may belong to the same layout. In Design View, select the control and choose Arrange > Remove Layout to resize it independently.

Does this method work for Access reports too?

Yes. Open the report in Design View, select the control, and choose Remove Layout on the Arrange tab before resizing it.

How do I resize the control after removing its layout?

In Design View, select the control and drag a side sizing handle to change its width. Save the form or report when finished.

Can WPS Office change an Access form layout?

No. Use Microsoft Access to edit Access form and report layouts. WPS Office is an alternative for documents, spreadsheets, and presentations.