Removing a character

[steve1111]

I have a main form with txtUser that [fosUserName()] to get the current logged on user. The issue i have is our format on the network is first.last

I also have a subform in the main form that runs off a combo box and will pull a custom form into the subform based on the user. I want to do away with the combo box and replace it with a hidden txt box with the control source being txt68 that houses the user name.

Here is my issue i cannot name a form with a "." in it so i need to find a way to remove the "." form the first.last network configuration when it travels from txtUser to the new hidden txt box that controls the subform.

Is this possible with as little VBA code? (I am a novice)

 

[Galaxiom]

=Replace(whatever,".","")

 

[steve1111]

Thank you so much, works great!