Newbie Question

  • Thread starter Thread starter AMY
  • Start date Start date
A

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.
 
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?
Click to expand...

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.
 
Back
Top