I am having an issue that water is building up on the inside of my metal window. has anyone tried putting foam tape on inside or outside to stop condensation?
What you really need is a dehumidifier, foam insulation on the inside will help but the window will probably still sweat as long as your humidity is high with cold weather. whatever you do don't block the outside weep drains at the bottom of your windows or the tracks may fill with water and possibly freeze solid on really cold days. They make plug in dehumidifiers that are not two expensive , other than that make sure when bathing that the exhaust fan is on, when cooking make sure the exhaust fan is on both help remove the moisture,,, here is a link to a small portable unit so you can see what I am talking about.
I'd say no & also give it a shot. But, not a thin tape. Go, for sticky backed weather-stripping that's at least 1/4" deep & wide enough to cover or slightly over-cover the frame (2-strips side by side if needed). If you do outside too then paint it to protect it from UV exposure & like Ed Beal said, don't block the weep-holes...you'll get a lot more "sweat" if you do that.
Otherwise, get storm windows to make a dead-air insulating space. Good news bad news...these will save you from getting new windows, but they cost about the same as new windows if you can imagine that absurdity.