Check Boxes

[Ev]

Can someone please supply me with the relevant VB code so that when a text box contains an amount of currency the check box will be ticked automaticaly<br><br>Chris

 

[DougP]

Assumptions:<br>&nbsp;your Checkbox name is &quot;Check1&quot;<br>The textbox on your form is &quot;Textbox1&quot;<br><br>Somenumber is a value you are checking against<br><br>&nbsp;&nbsp;&nbsp;&nbsp;If Val(Me![Textbox1]) &gt;= Somenumber Then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me!Check1.Value = True<br>&nbsp;&nbsp;&nbsp;&nbsp;Else<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Me!Check1.Value = False<br>&nbsp;&nbsp;&nbsp;&nbsp;End If<br><br>OK<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.