Removing spaces

  • Thread starter Thread starter puce576
  • Start date Start date
P

puce576

Hello,

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

Thanks a lot

Perrine
 
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
 
Back
Top