By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Report field limitations

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can bind a control to the result of a custom VBA function. In the
control source property enter '=YourFunctionNameHere()' (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_milenko" <ki**********@hotmail.com> wrote in message
news:ae**************************@posting.google.c om...
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?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.