Hello.
In an Access application I am trying to fix, there is a button that calls the macro ExportWithFormatting to export a report and it lets you choose between several formats. The thing is, when exporting the same report in RTF and PDF, there are several differences.
There is a header with client data that works ok in the PDF, but in the RTF some labels are duplicated and misplaced:
PDF CLIENT HEADER
-------------------------
Nº CLIENTE client number
NOMBRE name
DIRECCIÓN address
POBLACIÓN city
PROVINCIA province
COD. POSTAL zip code
REF. CLIENTE ref number
TELEF. telephone
NSTRUCCIONES: instructions
RTF CLIENT HEADER
---------------------------
Nº CLIENTE
NOMBRE name
NOMBRE DIRECCIÓN address
POBLACIÓN city
PROVINCIA COD. POSTAL province
COD. POSTAL zip code
REF. CLIENTE ref number
TELEF. telephone
INSTRUCCIONES: instructions
As you can see, the label NOMBRE appears duplicated in the RTF file before the label DIRECCIÓN, and the same happens with COD. POSTAL, that appears duplicated after PROVINCIA and then again in the next line, this time correctly.
I am not sure where to look. There are no duplicated labels in the report, and I cannot find any event that modifies the report in any way. The button call the macro directly, no custom VBA code involved...
In an Access application I am trying to fix, there is a button that calls the macro ExportWithFormatting to export a report and it lets you choose between several formats. The thing is, when exporting the same report in RTF and PDF, there are several differences.
There is a header with client data that works ok in the PDF, but in the RTF some labels are duplicated and misplaced:
PDF CLIENT HEADER
-------------------------
Nº CLIENTE client number
NOMBRE name
DIRECCIÓN address
POBLACIÓN city
PROVINCIA province
COD. POSTAL zip code
REF. CLIENTE ref number
TELEF. telephone
NSTRUCCIONES: instructions
RTF CLIENT HEADER
---------------------------
Nº CLIENTE
NOMBRE name
NOMBRE DIRECCIÓN address
POBLACIÓN city
PROVINCIA COD. POSTAL province
COD. POSTAL zip code
REF. CLIENTE ref number
TELEF. telephone
INSTRUCCIONES: instructions
As you can see, the label NOMBRE appears duplicated in the RTF file before the label DIRECCIÓN, and the same happens with COD. POSTAL, that appears duplicated after PROVINCIA and then again in the next line, this time correctly.
I am not sure where to look. There are no duplicated labels in the report, and I cannot find any event that modifies the report in any way. The button call the macro directly, no custom VBA code involved...