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
 
Back
Top