Simple question on making control visible

[ddean68]

Short easy version -

I have 2 fields that I need to compare values in - I need some text to be displayed ONLY if the two values match.

Thanks for the help in advance

 

[KenReay]

Hi

Define TextBox on the form set its recordsource to =IIF(Val1=Val2,"Values Match","&quot - wher val1, val2 are the names of your other two controls

set (text box) border style to tranparent, background style to transparent, althought box will be visible when values do not match, it will not show up since it will be same background as form, when values are equal text will show

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK