Much more info is required. This could be done via a formula, most likely you
will need a macro. However, w/o knowledge as to page layout, desired page
layout, info type, criteria, etc.; there is very little we can do with
regards to writing a macro for you.