Burt
Taking your «Name» field as an example:
1. Make a copy of the field, so that you've got two instances of it side by side, thus
«Name» «Name»
2. Select both copies and press Ctrl-F9. This wraps your fields in a new one, thus
{ «Name» «Name» }
3. Fill in & around the field braces, thus
{IF«Name»= "" "" "Name: «Name»"}
paying careful attention to the spacing and quote characters
4. Press F9 to update.
If you also want to suppress the empty paragraph when the result is empty, place all three sets of fields on the same line, thus
{IF«Name»= "" "" "Name: «Name»"}{IF«Position»= "" "" "Position: «Position»"}{IF«Salary»= "" "" "Salary: «Salary»"}
then insert paragraph markers thus
{IF«Name»= "" "" "Name: «Name»¶
"}{IF«Position»= "" "" "Position: «Position»¶
"}{IF«Salary»= "" "" "Name: «Salary»"}
(using a 'proper' paragraph mark instead of the ¶ character I've used).
An alternative approach for the «Salary» field would be not to make a copy, but to:
.. select it and press Shift-F9 to reveal its coding (ie {MERGEFIELD Salary})
.. add a switch to field field, thus
{MERGEFIELD Salary \# "Salary: £,0;;"}
.. Press F9 to update.
Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------
Burt said:
Someone would like to create labels that also incude the name of the field e.g.
Name: Carol
Position: Manager
Salary : £50,000
but if the Access data base where their data is has a blank for some data
they don't want the field name printed i.e. if in the above example there is
no Position in the data base the label should say
Name: Carol
Salary : £50,000
and not
Name: Carol
Position:
Salary : £50,000
Any ideas?
