Combo Box Value List Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Try your decimal places property in table design set to "Auto" and keep the
decimal property blank.
 
Back
Top