Conditional Format

[fenhow]

Hello,

Have a txtBox on a form, data is a value 1 or 2 based on a check box selection in an option group.

Want to show Completed versus 1 and Not Completed versus 2 in the txtBox on the form.

I seem to recall some kind of conditional format I could apply to the txtBox using an expression but I cannot locate it..

Any suggestions?

Thanks.

Fen

 

[pbaldy]

Do you mean something like:

=IIf(FieldName = 1, "Completed", "Not completed")