Combo Box Value List Source

G

Gary O

HI, I am having difficulty getting my combo box to format the Value List.

My valkue list is :
26.00;Annual;13.00;Semi-Annual;6.50;Quarterly;4.33;Semi-Monthly;2.16;Monthly;1.00;Fortnightly;0.50;Weekly

The combox box displays the whole part of the number but not the decimal part.

I need the decimal part to be saved so that I can use the data in my report
to convert an amount and then calculate what that amount is per fortnight.

Field1 "Amount"
Field2 "Frequency"
Calculated field "Amount/Frequency"

I have created an unbound field which I would like to store the result, but
the field is only using the whole number which does not calculate the amount
correctly.

As an example, $800 per month is not $400 per fortnight, but $369.23!

Can someone advise how I need to proceed.

Regards
 
A

ashg657

In the Combo boxes properties, ensure that Decimal Places is set to, in your
case, 2 or "Auto". Other than that, check your field parameters in the design
view of the table in question.
Hope that helps.
 
G

Gary O

Still no joy!

Form - Design - Combo Box
Format - General Number
Decimal Places - 2
Input Mask - !90.00
Row Source Type - List Value
Row Source -
26.00;Annual;13.00;Semi-Annual;6.50;Quarterly;4.33;Semi-Monthly;2.16;Monthly;1.00;Fortnightly;0.50;Weekly

Table - Field - General
Field Size - General Interger
Format - General Number
Decimal Places - 2
Input Mask - !90.00

I thought this would achieve what I am after which is to save the decimal
number based on my selection into the combo box field. I don't know why it is
only saving the interger part and not the decimal part.

Further assistance would be appreciated.
 
A

ashg657

Try your decimal places property in table design set to "Auto" and keep the
decimal property blank.
 
Top