A
a2kprogrammer
I have an unbound ole excel spreadsheet on my access 2000 report. On a group
header's format event I populate the A1 cell with a date and then format it
according to a language code coming from the result set.
Let's say the result set in English-Spanish-French.
The report will show this order: English-English-Spanish
This next time (and Nth) the report runs: French-English-Spanish
However, if I add a breakpoint and step through the setting of the format,
the report renders correctly each time: E-S-F.
Is there a refresh problem, or is the format event happening too late so
that the date formatting is getting applied to the next record? If so, the
why does adding a breakpoint and stepping through 'fix' the issue?
Thanks
header's format event I populate the A1 cell with a date and then format it
according to a language code coming from the result set.
Let's say the result set in English-Spanish-French.
The report will show this order: English-English-Spanish
This next time (and Nth) the report runs: French-English-Spanish
However, if I add a breakpoint and step through the setting of the format,
the report renders correctly each time: E-S-F.
Is there a refresh problem, or is the format event happening too late so
that the date formatting is getting applied to the next record? If so, the
why does adding a breakpoint and stepping through 'fix' the issue?
Thanks