Replace a character with another in a text box

[JHDavis]

I have a text box that is filled with data pulled from another databse.

The pulled format is [productcode].[itemcode]

How do I find the "." and replace it with a space?
For example, I need to go from DF6YT.7856 to DF6YT 7856.
I'd like to do this in the After Update event.

Thanks in advance.

 

[RoyVidar]

Try something like:
[tt]me!txtBox.value=replace(me!txtBox.value,"."," ")[/tt]

for 2000+ versions, for prior versions, have a look at RickSprs faq faq705-4342

Roy-Vidar

 

[randy700]

How about....
ProductCode = Replace(ProductCode, ".", " ")


Randy

 

[JHDavis]

DOH!

I forgot the ".value =" part.

Thanks very much!