How do I get the Minimum value from 4 text boxes on a form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RobH
    New Member
    • Jul 2007
    • 56

    How do I get the Minimum value from 4 text boxes on a form

    I have 4 text boxes on a form (A,B,C & D) and I need to have a button (when Clicked) make the 5th box (E) appear with the value from the smallest valued box.

    Eg
    A = 2
    B = 1
    C = 5
    D = 7

    Result
    E = 1

    I can work out the visible aspect being "Me.E.Visib le = True"
    I cant seem to find an equivalent to the MIN function - Any takers?
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    There's no function for this. You'll just have to code it.

    Comment

    Working...