Use paragraph formatting to control page breaks (Word
97-2000-2001-2002)!
When you're getting ready to print a document, it's important to
make sure Word's automatic page breaks don't separate lines that
should stay together. For example, you'll want to make sure a
heading sticks to the text that follows it, or you might want to
keep all the lines in a bulleted list together on the same page.
Thanks to the features offered on the Line And Page breaks
property sheet, there's no need to tweak your text, fiddle with
font sizing, or manipulate manual page breaks to control your
document's page layout. First, select the paragraph(s) you want to
correct. (If you want to control a single paragraph, you don't
need to select the whole thing--just place the insertion point
anywhere within it.) Next, choose Format | Paragraph from the menu
bar, and then click on the Line And Page Breaks tab.
--To prevent the paragraph's first line from printing at the
bottom of the page and its last line from printing at the top of a
page, select the Widow/Orphan Control check box. (Note: The
Widow/Orphan Control check box is enabled by default as a standard
attribute of Word's built-in Normal style.
Therefore, any paragraphs that use the Normal style, as well as
any paragraphs that use a style based on the Normal style, are
automatically assigned the Widow/Orphan Control attribute.)
--To prevent Word from breaking pages in the middle of the
paragraph, select the Keep Lines Together check box.
--To prevent Word from breaking pages between the current
paragraph and the one that follows it, select the Keep With Next
check box.
--To force Word to start the paragraph on the next page, select
the Page Break Before check box.
When you've finished, click OK. If you've configured Word to
display nonprinting characters onscreen, you'll see a small black
square to the left of each paragraph that's been assigned one of
these attributes. To view the effects of your alterations before
printing your document, click the Print Preview button on the
Standard toolbar.
Concatenating Excel Cells Containing Dates And Text!
Suppose you'd like to combine two Excel cells. Let's say that cell
A1 contains the text "Today's Date is," and cell D1 contains the
date 12/31/01. Go to cell A4 and enter
=a1&d1
then press Enter. What you'll get in cell A4 is "Today's Date is
37250."
To concatenate a text cell and a date cell, you first have to
convert the date to text. So go to cell A4 and type
=a1&text(d1,"mm/dd/yy")
then press Enter. Now cell A4 will display "Today's Date is
12/31/01."
Removing and adding subdatasheets to a view Access 2000!
In Access 2000, when you view the master table of a relationship
in Datasheet view, you'll typically be able to drill down to the
related data through a subdatasheet. When a subdatasheet is in
place, you can expand and collapse the view of any related data by
clicking the appropriate button in the leftmost column of each
row. You can even work with nested subdatasheets, such as when you
view the Northwind sample database's Employees table, which lets
you drill down to the related Orders and Order Details records.
Although this feature is convenient, it can also cause confusion,
especially for end users. If you'd rather not display a
subdatasheet, you can easily remove it by selecting Format |
Subdatasheet | Remove.
Note that this doesn't affect the established relationship between
the tables. To display related data with a subdatasheet, select
Insert | Subdatasheet while the parent table is in Datasheet view.
Then, choose the appropriate table or query you want to display,
select the appropriate linking fields and click OK. If a
relationship doesn't already exist you'll be prompted to create
one; however, you don't have to create a relationship to be able
to use a subdatasheet.
|
Things to Note
Starting 05/31/2004 Our new remote connection service will start!
If we cannot fix your computer problem by email you will be able
to setup a Remote Connection Session With Us.
|