How to remove extra spaces from a field?

[accessmatt]

Hello,

Is there a way to remove extra spaces in a field (after data is already in the database)?



Thanks,

[ItsMe]

I typically use the Trim() function. Sometimes white space is in the form of a carriage return and I will use the Replace() function too, to replace vbCrLf with ""