Report field limitations

[Great_milenko]

H, I've got a little problem I need to insert a formula about 4000
characters while the the expression field in the report only accepts
255 characters, is there some way around this, like to put it directly
in the program code or somewhat similair?

[Brendan Reynolds]

Re: Report field limitations

You can bind a control to the result of a custom VBA function. In the
control source property enter '=YourFunctionN ameHere()' (without the
quotes). Create the function, declared using the 'Public' keyword, in a
standard module.

4,000 characters is a horrendously complex expression. Now I don't know the
details of your application, so I could be wrong, but I'm inclined to
suspect that the need for such a complex expression may be a warning of a
more fundamental design problem.
--
Brendan Reynolds

"Great_mile nko" <kingmaster47@h otmail.com> wrote in message
news:aeeb46d3.0 402240223.45ace 50b@posting.goo gle.com...[color=blue]
> H, I've got a little problem I need to insert a formula about 4000
> characters while the the expression field in the report only accepts
> 255 characters, is there some way around this, like to put it directly
> in the program code or somewhat similair?[/color]