This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am working on an Access database on my laptop. When a table is in design view more than half of the bottom of the screen displays the Field Properties Pane. This makes it harder to work on the table by examining or moving the field rows, etc. Can one hide or reduce the size of the field property pane?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I agree regarding the normalization since I see a pattern of Short Text, Date/Time, Short Text, Date/Time. Most of us old seasoned developers would create a related child table with each different date creating a record. We all could be wrong since we don't have much other information to go on other than a high number of fields.
Answer accepted by question author
From your screenshot it does look to me like a matter of resolution. When I scale your image up to around the size of a 15 inch laptop screen the text and images are noticeably larger than on my screen, and mine shows more than twice as many lines for fields as in your case. I also think Scott is likely to be right about your table design, and that it is probably in need of normalization through decomposition. Without knowing what entity type the table is modelling, and what are the attributes represented by the columns I can't say more than that.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
The way Relational tables are designed, they generally have few fields so they are thin, but many records, (tall). A table with 49 fields is wide. And such a table is probably not designed properly. I don't remember creating any tables that had more than a dozen or so fields.
You might want to show us what your field names are and explain them and we can show you why there shouldn't be so many fields.
The reason it relates is because the problem you are encountering is not something more professional developers care about because we don't make wide tables.
Seems to me, most missed the question here.
Normalizing the database is not the question.
the simple question is how to control or get "more" or "less" room in regards to the properties window when in table design mode.
If you have separate windows turned on, then you can re-size like this:
So, you can control the space somewhat, but you have to enable windows in place of tabs. This may, or may not be of great help to you.
About the best?
Try to max that design window, and minimize the ribbon. That gets you what looks like to be the most room for fields, and the least space for the properties window. eg this:
The property sheet can be closed like any window by clicking the X at its top right corner, or can be resized by clicking and dragging its left edge. If you are referring to the field properties at the bottom of the design window, then this is an integral part of the window and cannot be hidden or reduced as far as I'm aware. For it to occupy such a large proportion of the window suggests you are using a low screen resolution.