Extending Character Length - still having problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
--
hth
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."
 
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.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I cannot find anywhere to enter text and nor can I find FieldSize! Is this
because my version of access is older?
 
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.
 
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.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
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.
--
hth
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?
Click to expand...

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.

--
 
Many thanks!



John Spencer said:
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.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
Back
Top