Hop do I format the contents of a bookmark in certain documents with access (1 Viewer)

atrium

Registered User.
Local time
Tomorrow, 08:01
Joined
May 13, 2014
Messages
348
I have a large merge facility via word template precedents under the control of Access 365 . In certain documents I want the Clients name to be in Uppercase. The default is that it is in normal text. So for the odd document when I need the Client name in upper case how do I format the content of the field to appear in upper case


Any help will be really appreciated
 
Last edited:

plog

Banishment Pending
Local time
Today, 16:01
Joined
May 11, 2011
Messages
11,611
I'm confused where this upper casing is to take place. We are in the VBA forum, but you mention upper casing a field like it might be taking place in a query. And then its unclear if only some records need to have the field upper cased and others not.

So my shot in the dark is that you need to use UCASE(). Here's documentation for in a query:


And here's in VBA:

 

bastanu

AWF VIP
Local time
Today, 14:01
Joined
Apr 13, 2010
Messages
1,401
If you are using true mail merge fields then look into using switches for those fields:
 

Users who are viewing this thread

Top Bottom