Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Beginner > B3 > < B2 | B4 >
Back to Access Beginner 3    Comments List
How Do I Make a Column Wider Upload Images   Link   Email  
Jan Bolhuis      
2 years ago
In design view I can't make the last column (description) wider. This is also the problem with the field properties. I can make the first column wider but not the last column.

How can I fix that?
Scott Axton            
2 years ago
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.
Jan Bolhuis      
2 years ago
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.
Jan Bolhuis      
2 years ago

Jan Bolhuis      
2 years ago
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.
Scott Axton            
2 years ago
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.
Scott Axton            
2 years ago
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.
Jan Bolhuis      
2 years ago
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.
Jan Bolhuis      
2 years ago

Jan Bolhuis      
2 years ago

Scott Axton            
2 years ago
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.

Jan Bolhuis      
2 years ago
Ok. Thank you for your answers and time.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 3.


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/21/2024 6:33:51 AM. PLT: 1s