Mail Merge and Input Masks

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

 

[Guest]

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.

 

[David Lloyd]

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?