Mailmerge from Access Query

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

M.L. Sco Scofield

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
 
Top