Problems with fractions in combo box

  • Thread starter Thread starter ChuckW
  • Start date Start date
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 tried to reproduce your situation but I do see the
fractions in the combo box after I selected one. When you
say " ... does not appear after it is selected." do you
mean "does not appear in the combo box? By the way, I made
both fields text and I'm sure you did too.
Geof.
 
Geof,

I think I figured it out. My problem was the the field
that I was storing the value in was not set up to accept
values that had decimal places such as .3125. Once I
changed this the English values appeared. It had nothing
to do with the fractions.

Thanks anyway,

Chuck
 
Back
Top