 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / September 2007Extending Character Length - still having problems
I tried to use the advice left in my other post of the same nature, but I cannot find datatype in my properties box for the text box whose character length I wish to increase. How do I increase without using that method? Rhianne, The length of characters allowed in a text field is controlled in the Table Design view. Select Text as the type for your field, and in the properties below, set the FieldSize to whatever length you need. Note: Text type fields can contain up to 255 characters. Memo type fields can contain up to 65,536 characters.  Signaturehth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." >I tried to use the advice left in my other post of the same nature, but I > cannot find datatype in my properties box for the text box whose character > length I wish to increase. > > How do I increase without using that method? I cannot find anywhere to enter text and nor can I find FieldSize! Is this because my version of access is older? > Rhianne, > The length of characters allowed in a text field is controlled in the [quoted text clipped - 8 lines] > > > > How do I increase without using that method? You don't change the length in the text box. You open the underlying TABLE and change the field length in the table. Once you have done that the text box should allow you to enter more characters into it. If not, then you would need to check the properties of the text box to see if there are any restrictions set in a validation rule or vba code behind the form or control. SignatureJohn Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . >I tried to use the advice left in my other post of the same nature, but I > cannot find datatype in my properties box for the text box whose character > length I wish to increase. > > How do I increase without using that method? I've gone into my table and made the appropriate column bigger, but no joy. Am I having problems finding the appropriate method as my version of access if older - 2000 I think. > You don't change the length in the text box. You open the underlying TABLE > and change the field length in the table. [quoted text clipped - 9 lines] > > > > How do I increase without using that method? Are you sure you changed the correct field? Pardom me, but did you by any chance just drag the column wider? That does not change the number of characters. In case you are misunderstanding, here are detailed instructions In database window click on tables Click on the table you want to modify --Open the table in DESIGN view --Click on the field name you wish to change -- Press the F6 key (or just click in field size at the bottom of the window) -- Change the field size to 255 (max size for text field) (If 255 isn't enough characters, then change the field type to memo in the upper half of the window) -- Close the DESIGN view and save when prompted If you have done that, then I have no idea what is causing the problem and therefore no idea on how to fix it. SignatureJohn Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County . > I've gone into my table and made the appropriate column bigger, but no > joy. [quoted text clipped - 20 lines] >> > >> > How do I increase without using that method? Many thanks! > Are you sure you changed the correct field? Pardom me, but did you by any > chance just drag the column wider? That does not change the number of [quoted text clipped - 39 lines] > >> > > >> > How do I increase without using that method? Rhianne, Your version of Access has nothing to do with this problem. Sounds like you just opened the table, and widened the column... that will not change the numbers of characters you can enter in that field. You need to... Find the table that contains the field you want to increase the size of. Right click on that table, and select Design View. ***The table must be opened in DesignView*** Find that field in the table design grid, and place the cursor in the Name column of your field. While the cursor is still on the field, the properties down below will show a FieldSize property. Change the length of the FieldSize to suit your needs. Post back with your results, and if you still have problems... be specific... try to describe exactly what you did in following these instructions. Signaturehth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." > I've gone into my table and made the appropriate column bigger, but no > joy. [quoted text clipped - 20 lines] >> > >> > How do I increase without using that method? > I tried to use the advice left in my other post of the same nature, but I > cannot find datatype in my properties box for the text box whose character > length I wish to increase. > > How do I increase without using that method? Using SQL code is another method e.g. to change to 100 characters wide: CurrentProject.Connection.Execute "ALTER TABLE MyTable ALTER my_column VARCHAR(100) NOT NULL;" Jamie. -- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.