How does the distance between the atoms affect the magnitude of attractive and repulsive forces between them

Actually, when two atoms come very close, the force between them is always repulsive, because the electrons stay outside and the nuclei repel each other. Since the force is repulsive at small r, and attractive at small r, there is a distance at which the force is zero.