Conditions

[john]

Hello,

Given the particular information in a cell, I would like
another cell in the same record to become populated with
1 of 3 possibilities. How do I go about accomplishing
this?

Thank you.

 

[Alan Fisher]

Look at the Conditional Formatting under the Format Menu
in design mode. You should be able to get what you want
from there.

 

[Marshall Barton]

Given the particular information in a cell, I would like
another cell in the same record to become populated with
1 of 3 possibilities. How do I go about accomplishing
this?

That's a pretty vague description, but one way would be to
use an expression in the "another" text box:

=IIf(txtbox = possibilty1, value1, IIf(txtbox = possibilty2,
value2, value3))