• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

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

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.
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
alunlewisAuthor Commented:
Cheers mate - you've clarified it for me.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now