Remove spaces from field in VBA?

H

Harmannus

Hallo,

How can i remove a space(s) from a field in VBA e.g. a zipcode: 9999 ZZ to
9999ZZ

Thanx for any help!

Regards,
Harmannus
 
D

Dale Fye

Update your ZipCode
SET ZipCode = REPLACE([ZipCode], " ", "")
FROM yourTable

HTH
Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Formating bolded text exclusively. 0
White space above heading inconsistently applied 1
how to check MS Word paragraph line spacing using vba script 1
ASK Field Formatting 1
(Word 2016/365) Removing white space between pages at a smaller zoom 0
How to remove external organization from Office. 0
Remove spaces from field? 2

Top