I have an Access 2000 database holding subscription IDs for my customers. The IDs range from a single digit e.g. "0" to multiple digits e.g. "1234567890", the field properties are 50 chars of text. I have just discovered that some of the fields only contain the subscription ID but some others contain the subscription ID plus 'space' padding up to 50 char length. Is there something obvious that I am doing wrong to cause this and more importantly how do I remove all these unwanted space chars padding the fields of my database. Thanks.