Mailmerge from Access Query

  • Thread starter Thread starter Imillar
  • Start date Start date
I

Imillar

When merging from an Access Query, the data is coming in
in UPPER CASE, in spite of an input mask being set in
table to prevent this. Solutions please.
 
An input mask is for display only while you are inside of Access.

When you export, you get the *real* data.

Depending on how you need to format the data, you can use the Format and/or StrConv functions to change the data in the query.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mailmerge from Access to Word 16
Email address in mailmerge using access 5
Access #Error & Excel Pivot 0
Using an access query for mailmerge 3
Change from all UPPER case letters 5
How do you connect Word 2003 to Access 2007 accdb database??? 3
Migration 97 to 2003 causes MailMerge to fail 2
Access 2003 to Word 2003 Mailmerge very slow 6

Back
Top