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,

 

[Pat Hartman]

I'm with Gasman. I also format my dates and money fields as well. It is quite easy to do with the query.

 

[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

 

[Pat Hartman]

I have tried that

What is "that" and what doesn't work? It is hard for us to help when we don't know what you are doing and what is wrong with the result.

You could also convert the data to Upper case in the control's AfterUpdate event or in the FORM's BeforeUpdate event. You CANNOT convert the data with a format. A format is a format, it does NOT affect what is saved.

Uppercase IS Caps so I don't understand that statement.

 

[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,

 

[Pat Hartman]

There is nothing sacrosanct about having a field occur only once in a query. You just need to map to the bookmark name correctly. Have you considered including two variations of the name in the query? One that is as the data is stored. The second is upper case.

 

[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.