Measurement Conversion

[tfaithw]

Hello!

I am rather new to Access and have frustrated myself to no end trying to figure this one out....
In a form, I need to be able to enter a measurement in inches and then have it save to my table. I also need to be able to enter it in centimeters, and have it convert to inches, ideally within the same box. I am envisioning having my input box, and then a combo box with "in" and "cm". I have set the default to "in" so if the data is entered in inches, everything is good to go, but i can't for the life of me figure out how to make my input box convert the data from centimeters to inches once the combo box is changed to "cm". (I think I probably just coming back to a circular reference or something, I'm not sure) .

I hope that make sense. Any ideas anyone has would be greatlly appreciated!

Thanks,
Tiffany

 

[bat17]

Assuming that you only want to store and display it in inches then you can use the AfterUpdate event of the combobox to change the data for you in code.
Your code would look something like:-

If Me.cboList = "Cm" Then
   Me.txtInches = Me.txtInches * 0.393700787
   Me.cboList = "In"
End If

shout if you need more detail.

peter