Web Spreadsheet Control on Access form

B

BS

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
does not loes 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.

Any one have any ideas?
 
Top