How to change the Case of the contents of a bookmark in word

[atrium]

This may not be the forum for the above question. But I running the merge in word via access

I simply don't know how to convert to UpperCase. e.g. I want the contents of BM70 to display in Upper Case

 

[Gasman]

I would do it in the query source for the MM

 

[bastanu]

Look up Word mail merge switches:

Formatting fields with switches

A collection of tips and add-ins to benefit Word users.

www.gmayor.com

Here is the one you need in this specific case:

Apply UPPERCASE format to merge field without changing case of field name - Microsoft Q&A

Hi, I am working on a mail merge template for a legal document, and need to apply the UPPERCASE format, however, I'm running into a problem because the name of the merge field is case sensitive. I'm using this in conjunction with the document automation…

answers.microsoft.com

Cheers,

 

[atrium]

I have tried that and it works for 80% of the times I use it. It's the other 20% that I need to convert Uppercase to lowercase and then Caps.

Or I could leave everything in lowercase and convert the BookMark to UpperCase when I need to

 

[atrium]

Sorry I should have explained my self in a much clearer way.
I have a number of documents using BookMarks to insert text from a query.
Some of the BookMarks when used in some documents they need to appear in UpperCase but in other documents that are required to be in
LowerCase
If I use [BM70 \* Upper] and insert BM70 via BookMark option - the result is still in lowercase

I'm using Office 365

 

[Gasman]

No idea as to how you are populating the bookmark, but a quick Google shows

Update Word bookmarks with formatted Excel data from Excel

The following code is intended to update Word bookmarks with formatted data from Excel, however the formatting doesn't come across and unsure why, would appreciate any suggestions. The formatted d...

stackoverflow.com

I *think* the codes are for Mergefields?

 

[bastanu]

Yes, the switches apply to Word mail-merge fields (as implied by the OP in the first post).
Cheers,

 

[emmawaston79]

I'm not sure what you're asking, but if you want to use uppercase, it's easy: just select the text you want to change and press SHIFT + F3 until the case you want is used.