Currency Field-Access Copy/Paste Problems to Word, Outlook

[dlhappy]

Hi:

In a transaction table, I have a currency field. When its Format was Standard, and Decimal Places was 2, if I did a copy of the table, which appears on a form together with data from a main table with names, addresses, etc.and pasted it to either MS Outlook or MS Word, the cents, even when .00, also displayed in a table in Outlook, etc. with the two zeros after the decimal point.

Recently, I changed the Format from "Standard" to the following:

#,###.##;(#,###.##)[Red]
Decimal Places: 2

In the database, the two decimal places always show, even when .00 and if the number is negative, it will show with ( ) and in red. So, everything is exactly as I want within the database

However, when I copy the table to Outlook, only if the cents are greater than 00 do the cents show. Otherwise, the numbers just have a decimal point and no digits after/to the right of, the decimal point. Also, in Outlook, negative numbers do have the parenthesis ( ), but they do not show in red as they do in the database.

Is there anything that I can add to the table design so that .00 will be copied from the database and be properly pasted to Word or Outlook, so that ".00" and not just "." shows, and also, that negative amounts will be pasted in red, as they appear in the database? (I know that I can change the font color in Outlook/Word, but I don't want to have to do that manually.

Thanks for any help offered.

 

[CJ_London]

The normal format for the style you want is

#,##0.00;[Red](#,##0.00)

I just tried this and copied to Word and to here:

(1.00)

You lose the red because the formatting is not copied over - what is copied is the characters. I'm not sure this will meet your requirements but in Outlook and Word you can use the format painter. Before pasting, right click and select red font, then paste. Clearly this won't work if you are copying a table with a mixture of positive and negative numbers.

So I think that solves half your problem

 

[dlhappy]

Thank you very much, CJ, that does solve the problem.