Newbie Question

[AMY]

I am a newbie and have a crazy question. On a form, I
have a combo box that is designed to pull up certain
diagnoses. My original Diagnosis table is set to be a
double field size, fixed format, with decimal place set at
3. In the table, the diagnoses look great with the correct
decimals, the problem is on the combo box, the decimals
have rounded up. For example, what should be 99.999 reads
as 100 in the combo box. How do I fix this?

Thanks so much.

 

[Jeff Boyce]

Amy

What format do you have on the combobox?

 

[Guest]

I have it as fixed. Is that correct?

 

[John Vinson]

I am a newbie and have a crazy question. On a form, I
have a combo box that is designed to pull up certain
diagnoses. My original Diagnosis table is set to be a
double field size, fixed format, with decimal place set at
3. In the table, the diagnoses look great with the correct
decimals, the problem is on the combo box, the decimals
have rounded up. For example, what should be 99.999 reads
as 100 in the combo box. How do I fix this?

Since you will never be doing arithmatic with diagnosis codes, I'd
very strongly suggest changing your table design to use Text as the
datatype for this field in both tables.

As for the cause of the rounding, I have to suspect that you have a
Double field size in the Diagnosis table, but that the combo box is
bound to a default Long Integer number field in this form's table. It
should also be Double.