Create a query using this table.
Change it to an Update query (Update on query menu.)
Access adds an Update row to the grid.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10090
Drag this field into the grid.
In the Update row, enter:
replaceing xxxx with the name of your field.
Execute the query.
Verify the data is right.
You can then open the table in design view, and change the Field Size to 4.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"rlbaer" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10090
>I have Access 2002 and have a table that I want to downsize the field size
> from 11 (text) to 4 (text). Currently this field is populated with 11
> characters. When I resize, I want to save the last 4 characters and NOT
> first 4 characters. Can someone assist me?