Change the Width of One Field in a Microsoft Access Form
Question details
Change the width of one control in an Access form or report without resizing other controls.

- 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.
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.
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.
In the Navigation Pane, right-click the form or report and select Design View.
Click the field control whose width you want to change. Make sure you select the control rather than its label.
On the Arrange tab, select Remove Layout to detach the selected control from the shared layout.
Drag a side sizing handle on the selected control to the desired width, then save the form or report.

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.

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.




