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

Posted on 2008-11-19
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 84

    Accepted Solution

    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

    Cheers mate - you've clarified it for me.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now