Removing spaces

[puce576]

Hello,

Could you tell me which expression i should use in a query
to remove spaces from datas ?

Thanks a lot

Perrine

 

[JL]

There is a replace function, but I am only be able to use
it as a function call. I create a update query and call
the function in a Modules.
Like this.
==========================================================
Query:
UPDATE Table1 SET Table1.TEST_FLD = RemoveChar([Table1].
[TEST_FLD]);

Modules:
Function RemoveChar(Arg1 As String) As Variant
RemoveChar = Replace(Arg1, " ", "")
End Function

 

[TPratt]

TRIM([FieldName])

 

[chas]

Hi Perrine,

the following Microsoft article should point you in the
right direction:

http://support.microsoft.com/?id=210103
(ACC2000: How to Strip Extra Characters from a String)

hth

chas