1

Topic: At request export in a monetary field copecks disappear

They do not disappear, and are reduced at display, at change of a format of a field again appear.
Whether it is impossible as that to make what it did not happen?

2

Re: At request export in a monetary field copecks disappear

All copecks or.00 when copecks are not present? What format in a cell before its change?
What method preempts request? If to use DoCmd. OutputTo formatting is inherited.

3

Re: At request export in a monetary field copecks disappear

antipod wrote:

are reduced at display

That is claims - to Excel. So you section were mistaken...
PS.  it there was unique "clumsy assistance" from that Excel th...

4

Re: At request export in a monetary field copecks disappear

Anatoly (Kiev);
It reduces copecks, I come into a format of cells, I select monetary - all is returned.
Simply I push the outswapping button in  on a tape. Also I tick off to save a format. At outswapping without saving everything is normal, but it is not beautiful

5

Re: At request export in a monetary field copecks disappear

Akina;
The format of cells sets  at outswapping, so that that in it

6

Re: At request export in a monetary field copecks disappear

You did not answer, as the cell format right after outswappings (to "I select monetary") looks.
And still - as the field format in the table looks?

antipod wrote:

Simply I push the outswapping button in  on a tape. Also I tick off to save a format.

It, just, also is analog DoCmd. OutputTo. And here I agree with antipod .

antipod wrote:

At outswapping without saving everything is normal, but it is not beautiful

And it is analog DoCmd. TransferSpreadsheet

7

Re: At request export in a monetary field copecks disappear

Anatoly (Kiev);
The cell format in  after outswapping too monetary but why that not the rbl. and the international character of rouble costs also copecks does not show type.