I am using MS Access 97. In using expressions in reports it limits you to "say" 10 IFF formulas in a single expression. Does XP allow the use of more than 10 formulas in a single expression?
I am using MS Access 97. In using expressions in reports it limits you to "say" 10 IFF formulas in a single expression. Does XP allow the use of more than 10 formulas in a single expression?
I don't know if it does or not. When an expression gets
that complicated, it's better to create you own function and
use that in the text box.
OTOH, a data bound expression like that is usually a symptom
of some kind of issue in your table structure or that you
should be using a query to help sort out at least some of
whatever issue you're using all those IIf functions for.
