First off I just wanted to say thanks to all the people that helped so far. I have been developing in vba for the past 3 weeks and have a pretty firm understanding of it. Well anyways heres my problem.

Im saving a date string in this format ("11/14/05") as part of the title of a excel spreadsheet I am generating from access.

The problem:You cant save a filename under this format obviously. So I want to change:

11/14/05 to 11_14_05

So basically I need the char position the concatinate & "_" where the "/" would have been. What is the correct syntax to do this in vba/visual basic access?