Web Spreadsheet control on Access Form

B

Bernard

I am using the Web Spreadsheet Control on an Access form and it functions
normally except when I use the Export method. The ouput Excel sheet loses the
sign on negative values in the colour red but keeps the font colour, though
it does not lose the sign negative values coloured blue.

I have tried to re-format the values programatically in the ouput file but
so far with out success, although I can re-instate the formatting manually.
I need to find a programmatic solution to process the formats, post export.
A
ny one have any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top