C
ChuckW
Hi,
I have a combo box on a form that is based on a query
called measurementquery which is based on a table called
measurement. Here are the values in my table: One has
the english system the other has metric. What I want is
for the English System Measurement to appear as my combo
box selection and then store the Milileters to a table
which I know how to do. The problem is that Any
Measurement value with a fraction does not appear after
it is selected. So when I choose "1/16 tsp" from my
combo box, the value does not appear. When I choose 1
Tsp it does. I tried putting quotes around all values
but that did not work. It does store a value in the
table even though it is not apeearing.
Measurement Mililiters
"1/16 tsp" 0.3125
"1/8 tsp" 0.625
"1/4 tsp" 1.25
"1/2 tsp" 2.5
"1 tsp" 5
"1 1/4 tsp" 6.25
"1 1/2 tsp" 7.5
"1 T" 15
"1 1/2 T" 22.5
"2 T" 30
"8 T" 120
"1/2 cup" 120
"1 cup" 240
"1 1/2 cup" 360
"2 cups" 480
"1 Gal" 3780
Can anyone help?
Thanks,
Chuck
..
I have a combo box on a form that is based on a query
called measurementquery which is based on a table called
measurement. Here are the values in my table: One has
the english system the other has metric. What I want is
for the English System Measurement to appear as my combo
box selection and then store the Milileters to a table
which I know how to do. The problem is that Any
Measurement value with a fraction does not appear after
it is selected. So when I choose "1/16 tsp" from my
combo box, the value does not appear. When I choose 1
Tsp it does. I tried putting quotes around all values
but that did not work. It does store a value in the
table even though it is not apeearing.
Measurement Mililiters
"1/16 tsp" 0.3125
"1/8 tsp" 0.625
"1/4 tsp" 1.25
"1/2 tsp" 2.5
"1 tsp" 5
"1 1/4 tsp" 6.25
"1 1/2 tsp" 7.5
"1 T" 15
"1 1/2 T" 22.5
"2 T" 30
"8 T" 120
"1/2 cup" 120
"1 cup" 240
"1 1/2 cup" 360
"2 cups" 480
"1 Gal" 3780
Can anyone help?
Thanks,
Chuck
..