Removing blank lines from labels
1) First ensure that the label frames are showing the field contents (data source
headings), rather than their underlying field names. If this is not the case, then
either press Ctrl+F9 or choose View > Field Names to toggle the view.
2) Next, ensure that you can see non-printing characters, such as paragraph
marks, line breaks and so on. If these are not already visible, choose
View > Nonprinting Characters from the menu bar, or press Ctrl+F10, or
click on the paragraph icon in the Standard toolbar.
You will now see that address field separation is created by line breaks ,
rather than paragraphs . As the suppression of blank address fields depends
on hiding paragraphs, not lines, you need to replace line breaks with
paragraphs as follows.
3) Click in the first label, at the end of the last data source address field in the
first line of the label. Press Delete to remove the new line character and then
press Return (or the Enter key) to insert a paragraph marker. Repeat this
action for each line in the address.
If the line spacing in the first label is not satisfactory, you may wish to correct
this before proceeding, by modifying the paragraph style associated with the
address. Unless you have changed it, the address uses the Default style.
Caution
The objective of step 3) is to replace all line breaks at the end of data
source address fields with paragraphs. Sometimes the address data field
may be longer than the width of the label and will wrap to the next
physical line: make sure that you are not misled by this into deleting and
replacing anything other than line break characters.
4) Click again at the end of the first paragraph to be conditionally suppressed and
then choose Insert > Fields > Other. Select the Functions tab and then
click on Hidden Paragraph in the Type column. Now click in the Condition
box and enter the details of the condition that defines a blank address field. It
has the general form of:
![Database.Table.Database field]
where the ‘!’ (NOT) character indicates the negative case and the square
brackets indicate the condition.
For example, in our Points database the condition to test if the Company field
is empty would be
![Points.Sheet1.Company] as illustrated in Figure 307.
To test for multiple conditions, use the operators AND and/or OR between the
conditional statements, for example:
![Points.Sheet1.Title]AND![Points.Sheet1.Last Name]
Click Insert, but do not close the dialog box until all lines have been amended.
5) Repeat for each paragraph to be conditionally suppressed, remembering to
advance the cursor to the end of the line in question before changing the last
element of the condition and Inserting the result.
312 OpenOffice.org 3.3 Writer Guide
Comentarios a estos manuales