Label Captions

If you've ever needed to insert line breaks in a message box prompt, you most likely built a string that incorporated a line feed or carriage return character. Unfortunately, label objects aren't as forgiving when it comes to using these characters.

If you're setting a label's Caption property with code, you'll find that the special control characters are interpreted as squares, since they're otherwise un-displayable.

To successfully insert a line break in a label caption, you need to include both a line feed character and a carriage return character, entered consecutively.

To do so, you can use the Chr() function, such as:

Me.Label1.Caption = "Line 1" & _
Chr(13) & Chr(10) & "Line 2"

Me.Label1.Caption = "Line 1" & vbCrLf & "Line 2"

Labels: Customize, General, Macros, Reference, Tips, VBA

2007 choices

Office 2007 uses OfficeArt to format text boxes, graphics and pictures.

It's available in Word, Excel , and PowerPoint, but it is most active in PowerPoint and Excel.

Here's a description:

Office PPT Art


See all Topics word

Labels: Customize, Formatting, General, Graphics, Tips, Tutorials

Ugly when you look close

"From the company that popularized Arial, here are three examples of bad typography in Microsoft Word.

Bad typesetting in Word finds its way into résumés, business plans, research papers, government documents, even published books.

These small inconsistencies and imperfections may be un-noticeable in small doses, but paragraph-after-paragraph they stack up-resulting in ugly, visually in-cohesive documents.

Word isn’t for professional typography work, but that's no excuse for these typography sins.

Arial:



Garamond



Here's one that shows it can be done right:

BatangChe





Examples of Bad Typography




See all Topics word

Labels: Fonts, General, Tips

More of a good thing

1. Click the Microsoft Office Button , and then click Open.
   
   
2. Open the document that you want.
   Make the changes that you want to appear in all new documents that you base on the template.
   
   
3. Click the Microsoft Office Button , and then click Save As.
   
   
4. In the Save As dialog box, click Templates if your computer is running Windows Vista, or click Trusted Templates if your computer is running Windows XP.
   
   
5. Give the new template a file name, select Word Template in the Save As type list, and then click Save.

Labels: Documents, General, Reference, Templates, Tips, Tutorials

Measure by Measure

About the only thing I don't see is that you can bring up the Page Setup dialog box by double clicking in the dark area of the ruler that indicates the margin.

Once again this tip comes from the Microsoft Word MVP site:

Ruler of all you survey:
How to make the best use of Word's rulers

Here's the spot to click to show rulers in Word 2007-10:






See all Topics word

Labels: Documents, Formatting, General, Reference, Tips

More to come

You can place the word "More" or "Continued" at the bottom of every page except the last one.
The field, for those of you who know how to use them is:

{ IF { PAGE } = { NUMPAGES } "" "more" }

You can't just type in the brackets, you must use Insert>Field or Ctrl+F9.

For step by step instructions, go to:
How to Control the Page Numbering in a Word Document on TechTrax

Here is a more sophisticated formula:

{ IF { PAGE } < { NUMPAGES } "Continued on page {={PAGE} + 1}" "Last Page"}

Also see the Word MVP site
How to control the page numbering in a Word document

See all Topics word

Labels: Documents, Fields, Formatting, General, Reference, Tips, Tutorials

Remember the past

"Before the development of personal computers and word processing software,
documents were produced on typewriters."

Labels: General, Reference