[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Why does Access 2003 lose sterling currency formatting on paste into Word?

Posted on 2008-11-19
Medium Priority
Last Modified: 2012-06-21
If I create a table in Access, populate it with some numbers, some with a pound sign, some with a dollar sign preceding them, then save and paste into Word, the pound signs are lost but the dollars remain.
Question by:alunlewis
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 22993098
Access stores only data, not formatted data (unless you're storing this as a Text file, and you're actually storing the formatted value, like $3.44). You can export this to Word, if need be, and your export routine can sometimes preserve the formatted data. Click File - External Data - Export and see if you can get that to work.

Author Comment

ID: 23003344
Cheers mate - you've clarified it for me.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question