Hi Tony,
 
John was referring to the Update QUERY
 
what is the exact error message that you get? 
how many characters are in the field before you add anything?*
how many characters are you trying to add?
how are you doing it?  if you are pasting, this may be the problem

*You can make a query to show the number of characters in a field like this:

SELECT [fieldname], Len([fieldname]) as LenField
FROM [Tablename]
WHERE ([fieldname] Is Not Null);


Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

--- On Mon, 1/12/09, trandel2003  wrote:

I did try creating a new field and then ran an update query to copy
the old field. It still will not allow me to add additional chars up
to the maximum unless I increase the field size beyond the original
100?

I dont quite understand your suggestion re running an UPDATE?

Regards

Tony Randell

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas"
<JohnV@...> wrote:
>
> Tony-
>
> A Text field is variable length up to the limit of the number of
characters
> that you specify when you define the field. If you defined the
field as
> 100, you should be able to type additional info in a field that has
fewer
> than 100 characters.
>
> You could try the define a new field and then run an UPDATE to copy
the
> data, but instead use:
>
> UPDATE MyTable
> SET NewTextField = Left([oldMemoField], 100)
>
> John Viescas, author
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
trandel2003
> Sent: Monday, January 12, 2009 2:13 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Text field size
>
> Hi
>
> I have a puzzling problem with text field size.
>
> I converted a memo field to a text field and limited the field size
> to
> 100 characters. Now I find that the information has been truncated
> (as
> expected) but at a random size. Even worse is the fact that I cant
> add
> any further information to the field even though there are in
theory
> characters available. e.g. field is truncated to 89 chars and will
> not
> allow any additional characters to be entered.
>
> I have tried to copy the memo field into a new text field instead
of
> changing the file design. I then ran an update query to move the
memo
> field into the text field bu without success.
>
> If I change the field size to +- 130 characters I can add more
> characters but I am still ending up with variable length field size.
>
> Any ideas very welcome
>
> Regards
>
> Tony Randell
>
>





[Non-text portions of this message have been removed]