If Value entered is outside of range then activate comment box

[blh5]

Hello,



Is there a way to activate a text field only if the value entered in another field is outside of a certain range?.... for example if field1 is <5 OR >10 THEN activate the other text field....


Thank you in advance for your help!

[pbaldy]

This type of thing?

http://www.baldyweb.com/ConditionalVisibility.htm

[orange]

if somefield <5 or somefield >10 then
thattextbox.visible = true
other things to do with thattextbox
else
thattextbox.visible = false

endif

(untested, just a thought)

[blh5]

Perfect! Thanks for the fast response!

[Missinglinq]

Note that you'll typically need that code in the AfterUpdate event of the pertinent Control, (somefield, in the example) as well as in the Form_Current event.

Also note that this will only work for a Single View Form. To do something similar for Continuous View or Datasheet View Forms requires using Conditional Formatting, and CF does not allow form making Controls either Visible or Invisible, only for Enabling/Disabling them.

Linq ;0)>