Larry said:
No, you need to prevent the erroneous values from getting to some control on
the Report. You can be sure it is not Access sitting there, trying to figure
out ways to complicate your life, and deciding that "it would be interesting
to see mogens squirm if I replaced some valid data with HTML". The first
step is to determine why/how the HTML is getting into the database records
that you are reporting.
Could you clarify just what, specifically, you mean by, "When printing for
instance an invoice using MS-Access, as an alternative to the build in
invoice report, I get this html-code included in the report output."?
Larry Linson
Microsoft Access MVP
The database I'm using is a MySQL database for an oscommerce website. In
oscommerce there are printout routines for the invoices on a per order
basis.
What I need to produce is a daily set of packing lists and invoices for
my warehouse (for pick/pack and despatch purposes). So I will make my
own version of the invoice report using MS-Access in stead of using the
php-code normally generating these invoices. Then I can also batch
produce invoices as this is quite timeconsuming to do otherwise.
For various reasons, the oscommerce programmers have chosen to put some
html-code around the text, or to be more precise: There are in some text
strings a "<b>" and "</b>" at beginning/end. No other types of
html-codes. Of course this is fine for oscommerce intended use, but for
my purpose it's a "pain in the ass" ;-)
Mogens
