Andy, is there any chance that this text field is a fixed-length field?
You can't tell through the interface, but press Ctrl+G to open the Immediate
window, and enter something like this line:
? ((dbEngine(0)(0).TableDefs("MyTable").Fields("MyField").Attributes And
dbFixedField) <> 0)
Substitute the name of your table and your field. If you get a response of
True, it is a fixed length field. You need to create the table with normal
text fields, use an Append query to populate it from the other table, with
Fixed width fields cannot be created through the interface, but you can
create them programmatically with DAO (by setting the attribute of the
Field), with ADOX (by setting the Fixed Length property of the Column), or
with a DDL query (a CREATE TABLE statment using CHAR where you should use
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.