how to get rid of white space in table field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 23 Dec 2006 03:09 GMT

Hi,

There are a lot of white space inside each table field after getting Access
DB created with importation from excel file. Then the table and
forms/reports are looking bad.

Is there a way to automatically remove them? Or do we have some way to do
similar thing on excel file first?

Thanks.

Ste

Reply to this Message

Tom van Stiphout - 23 Dec 2006 04:44 GMT

You could run an Update query:
Update SomeField set SomeField = Trim$(SomeField)
From SomeTable

-Tom.

>Hi,
>
[quoted text clipped - 8 lines]
>
>Ste

Reply to this Message

Larry Linson - 23 Dec 2006 09:43 GMT

> Hi,
>
> There are a lot of white space inside each table field after getting
> Access DB created with importation from excel file. Then the table and
> forms/reports are looking bad.

What do you mean by "white space"? Are you talking about spaces or blank
characters at the beginning or end of the data, or are you talking about the
size of the display area for the Field in Datasheet View or the size of the
Controls in Forms and Reports (though I am reasonably sure that the size of
the data is not going to auto-adjust the size of Controls in Forms and
Reports).

> Is there a way to automatically remove them?
> Or do we have some way to do similar thing
> on excel file first?

As has already been suggested, if it is leading or trailing blanks, the Trim
function will remove them.

Larry Linson
Microsoft Access MVP

Reply to this Message

Steven - 24 Dec 2006 14:46 GMT

Thanks guys. I'll try.

>> Hi,
>>
[quoted text clipped - 18 lines]
> Larry Linson
> Microsoft Access MVP

Reply to this Message