Formatting button with preset formats

  • Thread starter Thread starter twaccess
  • Start date Start date
T

twaccess

I have a rolling report where I update issues on a timely basis and wha
I do is type the new information in an existing cell full of previou
information and then carefully format the new text so that it is Bol
and 2pts larger in text. This helps to highlight the new items.

Once the report has been faxed I globally format the text to the sam
size to await any new text.

Is there a code which I can attach to a button whereby I select the ne
text and then press the button so that it formats both bold and size a
the same time please ?

Thanks


T
 
Hi TW
Record a Macro doing exactly what you have described.
Bold, 2pts larger, print, reformat to original size.
Once the Macro is done, create a Command Button using your
Forms Toolbar.
Place the Button somewhere on the screen. Right Click on
it to change it's name from Command Button to whatever you
prefer and then right click on it again and assign the
Macro you have created, to it.
Now, whenever you click that button the Macro will run all
of the above commands.

Regards
Michael
 
Back
Top