View Single Post
  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Xanbaby Xanbaby is offline
external usenet poster
 
Posts: 22
Default Formatting an inserted database field

Duh. Yes, of course, applying *\ CHARFORMAT to the {Database} field is the
answer, can't believe I overlooked that, not enough coffee obviously.
Unfortunately for me though, it's thrown up a weird knock on effect.

Following population of the mailmerge, the field populated and aligned as
normal UNTIL I applied the *\ CHARFORMAT to the {Database} field in the
master document. Once this is completed, the formatting does indeed change
to Bold, however a hard carriage return is also appearing before the field,
so the field is now misaligning.

I have analysed the document, and after the merge is completed have
discovered the following:

1. When viewing the document without Show/Hide formatting selected (and
before CHARFORMAT is applied to the field in the master document), all looks
fine.
2. When viewing the document with Show/Hide Formatting selected (and before
CHARFORMAT is applied to the field in the master document), there is a
carriage return before the field (this disappears again once the Show/Hide
Formatting is turned off, and the document also prints correctly. I am
unable to manually delete the carriage return. This is puzzling me
greatly).
3. Once the CHARFORMAT is applied to the field, the carriage return appears
in the merged document, and the document misaligns.

So, to summarise, a carriage return is somehow magically creeping in, but
while there, doesn't cause the document to look/print incorrectly unless
CHARFORMAT is applied to the field.

Don't think coffee is going to help me on this, any ideas would be greatly
appreciated.


"Peter Jamieson" wrote in message
...
When I looked at your screenshot, there was no \*Charformat switch at the
end of the { DATABASE } field. What Doug was saying is that you need that
switch /and/ to apply bold formatting to the D of the DATABASE field (or
the whole field, if you like)

It works OK here but I wouldn't want to predict what happens if your table
flows over more than one page.

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Xanbaby wrote:
Sorry, meant field "BED.DIVISION", ignore reference to "BED.TEL" in
earlier post.

Any assistance would really be greatly appreciated.

"Xanbaby" wrote in message
...
Yes I have. Weirdly, when "Toggle Field Codes" is carried out on the
field,
the toggled codes are in bold, and I've re-applied bold many, many times
to
the toggled codes and the field when it's not toggled, however when the
mail
merge is run, it loses the formatting.



I'm attaching (hopefully!) a jpg with the toggled code, in the hope that
it
may assist. The field BED.TEL" is in the main database, the rest of
the
code is looking at a small separate database.



Any further advice you could give me would be greatly appreciated.

"Doug Robbins - Word MVP" wrote in message
...
Have you applied Bold formatting to the first character of the field to
which you have applied the charformat switch?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Xanbaby" wrote in message
...
Using Word 2003, I have a mail merge which also has an inserted
database
(by using Insert/Field/Database, browsing to the database, and
inserting
the conditional database as a field excluding formatting). This
database
is used to generate a telephone number dependant on data in the main
database (and I have to do it this way, unfortunately!!!!).

So, I have an inserted field which produces a result and displays on
the
document. All working fine except; I can't seem to apply any
formatting
to the field (all I want in this instance is to make the result bold).
Teh field is embedded in a few IF commands, and I've replaced *
Mergeformat with * Charformat wherever I could find them, all to no
avail.

Any ideas on how to make the formatting stick once the mail merge ins
run
would be greatly appreciated, as it's driving me absolutely nuts.