Unable to fit expression in control source

[Amit]

Windows XP, MS Access 2K
=========================
Hi,

I have an expression in the source control of a textbox
that consists of multiple IIf statements, and as a result,
has more than 2048 characters, which apparently is the
limit for an expression.

Is there a way around this?

Thanks for any help or pointers.

-Amit

 

[Ken Snell [MVP]]

Yes. Use VBA code to write the desired value into the textbox.

 

[Amit]

-----Original Message-----
Yes. Use VBA code to write the desired value into the textbox.

--

Thanks, Ken.

-Amit