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
 

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
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Page numbering with Merged Document and IF statements 1
Creating a Chart on form from selected data in query. 0
Help creating a search form in Access XP 0
Mailmerge recepients list blank (pulling from Access query) 0
QBF & Query Malfunction 0
Change from all UPPER case letters 5

Top