=trim for Access

[respree]

Hello:

Does anyknow know the built-in function in Access 2002 that will reduce two or more consecutive spaces in a string down to one.

Its the equivalent of =trim in Excel.

I've tried the TRIM command in Access, but that doesn't seem to work.

Thanks for your help.

 

[AUcane]

TRIM works in Access.

If you have a table with the field name "CLASS" that you need to trim, the following is your function in design view:

newclass: TRIM([CLASS])

you don't need "="

 

[respree]

Thanks for your response.

I've tried that exact formula and it doesn't work for me...

 

[AUcane]

1) what version of access are you using?
2) what is the name of the table?
3) what is the name of the field you're trying to trim?

 

[Juan Pablo González]

Moved to MS Access

 

[respree]

1) what version of access are you using?
Access 2002, SP-2

2) what is the name of the table?
T:Keywords Refined

3) what is the name of the field you're trying to trim?
KeywordCombo

In Query (field),

Keyword: Trim([KeywordCombo])

I've also tried,

Keyword: Trim([T:Keywords Refined].[KeywordCombo])

Neither seem to work...