pull the higher of the two values

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

Can someone please suggest how i would format a text box to take the
higher value of two other text boxes?

ie.
Textbox1 =100
Textbox2 = 200
textbox 3 will update itself with the higher value (either textbox 1
or 2).

note the textboxes are formatted for numbers only.
I was going to have a macro update textbox 3 using the "afterupdate"
property of Textbox2

thanks,
Steve
 
Use the following as the Control Source of Textbox3:

=IIf([Textbox1]>[Textbox2],[Textbox1],[Textbox2])

and it will update itself - no VBA or Macro needed

HTH
Jon


Can someone please suggest how i would format a text box to take the
higher value of two other text boxes?
Click to expand...
ie.
Textbox1 =100
Textbox2 = 200
textbox 3 will update itself with the higher value (either textbox 1
or 2).
Click to expand...
note the textboxes are formatted for numbers only.
I was going to have a macro update textbox 3 using the "afterupdate"
property of Textbox2
Click to expand...
thanks,
Steve
Click to expand...
Click to expand...

that's great - thanks Jon
 
Back
Top