MS Access Database with External Data - Web Spreadsheet control on Access Form

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Web Spreadsheet control on Access Form

Bernard

2005-11-21, 11:24 am

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?
--
BS

Sponsored Links