Pesky Punctuation

[FoeHunter]

I’m working on pulling a person’s name from their profile to have it automatically populate a textbox on a form. Unfortunately, the names are stored in a Firstname.Lastname format. Is there a way to automatically remove the “.” from the result in the code below?

I’ve tried to search the forums, but couldn’t find anything, however, it is Monday and my brain isn’t working at full steam so I apologize if this is a repeat post of something someone has already answered.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>

Private Sub Command3_Click()
    UserName = Environ("USERNAME")
    Me.Text1 = UserName
End Sub

 

[revans]

Perhaps this

Me.Text1 = Replace(UserName,"."," ")

hth,

Rich

 

[FoeHunter]

As always, works perfectly. Thank you very much.