When would the force be the greatest?

That depends on the situation you are thinking about. For example, a gravitational force is greatest when the objects are closest together.