VB String Constant for a SPACE?  ?

Whats the VB String Constant for space? So I can replace Space's for  's
Replace(Field,SPACE, " ")

I just don't know what to use for the Space.
LVL 2
fredmastroAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
deightonConnect With a Mentor Commented:
chr(32)
0
 
deightonCommented:
or

vbKeySpace      
0
 
fredmastroAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.