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