finding max value in control of form

R

ryan c

i have a three control the text1, text2, and text3. but in the text4, i want
to return the maximun value of the three control. what will i do?
 
W

Wayne Morgan

See if this equation will do it.

=IIf([Text1]>=[Text2] And [Text1]>=[Text3], [Text1], IIf([Text2]>=[Text3],
[Text2], [Text3]))
 
Top