I created an IIF statement... that selects text for display in a textbox... apparently using a colon within a string in an expression is a no no... because I'm given the following error "Colons and line terminators are not valid in expressions." - is there a special character I can use... how do I get around this?

=IIF(MyComparison, "MyHeading:", "")

Are you trying to use a field or parameter in the text box?

--
Ben Sullins
Sql Developer - Our Vacation Store