Solved

Defining a column in  access to increase the length of the column

Posted on 2013-06-21
2
375 Views
Last Modified: 2013-06-21
It appears that the column width in access is too short and some of the names are being truncated.  How can I define the columnn width to be large enough to fit the largest string.
0
Comment
Question by:morinia
2 Comments
 
LVL 39

Expert Comment

by:als315
ID: 39266584
Try to change field's type from text to memo
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 250 total points
ID: 39266777
Go to table design and check the length of the field.
A normal text field can be expanded to hold 255 characters, enough for most names.

/gustav
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question