Expression Help

[fenhow]

Hi,

I have a txtbox that has a percent in it, (txtbox1)

I have another txtbox (txtbox2) that I want to place a value in based on a condition.

If txtbox1 is > or = to 1% Show "Yes" in txtbox2

Can someone please help me, I am trying to do this with a conditional format on a form.

Thanks.

Fen How

 

[apr pillai]

Write the following expression in TxtBox2

=IIf([txtBox1]>=0.01,"Yes","No")

Conditional Format can only change the Color (Font or Background) of TextBox2.