P
Piet
Hi,
I had some reports working fine in Access 97, with long expressions (concatenating strings and functions) in text box control
sources.
Since the conversion to Access 2000 these expressions still work, but I am no longer able to edit them in the expression builder, as
the expression length is limited to 2048 characters. So I cannot change the reports, although they do work as they are.
How to deal with this? I tried to have the text box control source filled by VBA code, "on the fly", but this doesn't work either.
It seems impossible to have the text box filled on the printing event of the detail section?
I tried to have the concatenation done at query level, but in the query expression builder the problem is the same: long expressions
impossible.
Any help would be appreciated.
Thanks in advance.
Piet
I had some reports working fine in Access 97, with long expressions (concatenating strings and functions) in text box control
sources.
Since the conversion to Access 2000 these expressions still work, but I am no longer able to edit them in the expression builder, as
the expression length is limited to 2048 characters. So I cannot change the reports, although they do work as they are.
How to deal with this? I tried to have the text box control source filled by VBA code, "on the fly", but this doesn't work either.
It seems impossible to have the text box filled on the printing event of the detail section?
I tried to have the concatenation done at query level, but in the query expression builder the problem is the same: long expressions
impossible.
Any help would be appreciated.
Thanks in advance.
Piet