[Burt]

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?

[macropod]

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" wrote in message ...
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?

[Burt]

thank you for your swift response. I'll give it a go.

"macropod" wrote:

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" wrote in message ...
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?