Deleting Extra Spaces After Name In Access

[jgarzoli]

Hi,

I have a field in a table that I imported a whole bunch of last names into. The names all have quite a few blank spaces at the end of each. So when I try to report with the last name field, The Last name pushes the first name off the page because of all the extra spaces.

Is there any easy way to delete all blank spaces after text? I'd rather not go through 4,000 individual records deleting the spaces after each last name!

Thanks in Advance,

Jeremy

 

[BenRowe]

Did you try a search-replace? It may be some sort of strange space so copy one of them -- that way you can paste it in the search box. Select the entire column and go to Edit - Find - paste the space char - and replace with nothing.

 

[jgarzoli]

Tried the find and replace, but no luck. Thanks though.

 

[RoyVidar]

Did you try the advice from r937 on one of the other sites you've posted this question on? Their advice seems spot on, should it be extra spaces.

Though usually, Access strips of leading and trailing spaces in text fields automaticly... wouldn't be surprised if it contains other non print characters.

Roy-Vidar

 

[fredericofonseca]

I would normally use the trim function
update customer2
set fld1 = trim(fld1)

set fld1 = trim(fld1), fld2=trim(fld2) ....


on all fields that may require it.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[jgarzoli]

Yeah, the rtrim ended up working perfectly. Thanks.