Jan are you speaking about the design of the table or how it looks on your form?

Can you provide us a screenshot of what you are talking about?
See Image Uploads if you don't know how.

I just figured out that when I make the column at the left side of the last column much wider, that the last column also becomes wider. So that prolbem is fixed. However how can I set the columnwidth at the exact width which I want.

Hi Scott. The screenshot is the result after making the first column much wider (and the second column of the design view). The question is how I can cotrol the width of the last column by myself.

Jan you are designing the TABLE - what fields and properties are in the table.  This has nothing to do with the width of the field on a form.  

You can set the number of characters to a specific number.  For instance if you never have states that are more than 2 characters you can change that from the default of 255 to 2.  Though Richard has done some experiments that has shown that is not necessary now. It used to impact the size of your database but not so much any more.

If you want to see more info on your FORM you can make your field wider (or taller) on the form.  Keep in mind if it is shorter than what you can see the data is still there.  For instance if your text box for a field on the form is only wide enough to display 5 characters but your field size (in the table) is 255 the data will still be there.  You just have to scroll to the right or left using your arrow keys to see additional info.

If that didn't answer your question let me know.

BTW the Description in the Table Design is really just a note to you, or your users, and not really used in the database.
If you put something in the description there then the description shows up in the status line at the bottom of a form.

If you need a description in your table you can make a Description field that you can use for your data that will be stored in your db.

You might want to revisit Lesson 4 in the Access Beginner 1 Lessons to refresh your understanding.

Thank you Scott. I'm probably not clear. I just want to have the last column wider when I'm in the design view. So that I can read the text. Or when I'm using a pull down menu in the field properties, that I can see the format and the examples to avoid the scroll bar. When I'm making the column to the left a lot wider, the last column will also become much wider. I am wondering if I can control the width by myself. By the way, after closing access and start it again, the last column is small again. I will upload two screenshots. Before and after.

You can adjust those while you are designing but once you close the table design Access doesn't save those settings.
To the best of my knowledge there isn't a way to do so.

Sorry!

Ok. Thank you for your answers and time.