In Firefox it's also View > Text Size and you can choose to increase, decrease of reset to default.
It will only work on sites which use relative text sizes. Recent accessibility laws mean that most big sites and 'public service' sites (.gov, hospitals, councils etc.) should resize OK but lots of smaller sites and arty sites won't... It also won't work on Flash based sites (with lots of graphics and animation) or on text rendered as images.