Changing field based on size

Hello all,

Hope this insn't a double post the first didn't seem to go..

I have data that shows the measurements of an item. The fields are:

Length (L)
Height (H)
Width (W)

Unfortunately our users can’t seem to enter in the right data for the right
field, meaning the Length might be in the Height field. I am unable to do
the check during data entry since I am just linking to this table and not the
owner.

A constant in this is:
Length will always be the largest
Height will always be the middle
Width will always be the smallest.

How could I code this in vb to check and update this with out many if
statements?
.

Relevant Pages