None of the common antibiotics affect sperm production. The most common one that can have an effect is sulphasalazine, which is prescribed for inflammatory bowel disease. For diseases as serious as this, it is obviously important to take the treatment as the effect of the illness can be more of a barrier to fertility than the treatment. Tetracycline for acne is fine – in fact tetracyclines are often used to treat infections in the testicles in order to increase fertility.