In extreme cases it is necessary to just repaint if the hard water spots are too badly etched into the paint. I have seen limited success with an acid bath with pool acid, but I don't know the proper dilution. This must be done with extreme care so don't try it unless you are familiar with using such harsh chemicals.
