By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

how to get rid of white space in table field

P: n/a
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
Dec 23 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Sat, 23 Dec 2006 03:09:12 GMT, "Steven" <sc*****@verizon.net>
wrote:

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

-Tom.
>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
Dec 23 '06 #2

P: n/a

"Steven" <sc*****@verizon.netwrote in message
news:s51jh.1183$kD4.212@trndny06...
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
Dec 23 '06 #3

P: n/a
Thanks guys. I'll try.
"Larry Linson" <bo*****@localhost.notwrote in message
news:nT6jh.319$cI.127@trnddc05...
>
"Steven" <sc*****@verizon.netwrote in message
news:s51jh.1183$kD4.212@trndny06...
>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


Dec 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.