Mail Merge and Input Masks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a table from Excel into Access and placed input masks on the
table. This looks fine in access but when I then mail merge into Word the
original data is shown. i.e. All capitals or all lower case. How can I
overcome this problem?
 
I think you will need to work with the Format property, which affects how the
data is displayed. The Input Mask appears to only affect how data is entered
in a field or control.
 
The following KB article shows one way to overcome this issue. You may want
to specifically consider the StrConv function to deal with string in all
caps or all lower case.

http://support.microsoft.com/default.aspx?scid=kb;en-us;197520

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have imported a table from Excel into Access and placed input masks on the
table. This looks fine in access but when I then mail merge into Word the
original data is shown. i.e. All capitals or all lower case. How can I
overcome this problem?
 

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

Input Mask in tables 2
How do I make input mask from access appear in word mail merge? 2
Input masks 1
Input masks 4
Specify Input Mask Format in Query 6
input mask - capitalize first letter? 7
Input masks 1
Case being changed in table 1

Back
Top