By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Wierd Combo Box Behaviour!

P: 14
I have created a combo box with the following properties:

RowSourceType: Value List
RowSource: "0%";"10%";"25%";"36%";"37%"
Bound to column: 1
Limit to List = Yes
Default Value = None
Format: Percent
Decimal Places: 0
Column Count: 0
Control Source: Discount field in a table.

When i load the form and select a value from the combo box, only "0%" appears. I am able to view all other percentages, but when i select any one of them, only 0% appears. I have no clue why is this happening.

Now, if i change the Bound to Column property to 0, then i am able to select the value normally. So, if i select 10% from the list, 10% appears in the combo box.

I am ok to set the Bound to column property to 0, but the problem comes when i need to calculate the discounted price. I have a function that takes the value from this combo box and then calculates the price.

When the Bound to column property is set to 0, the compiler takes the position of the value in the list. So if i select 10%, the cmbDiscount.value displays 2 and not 10%.

I am getting really frustated and don't know what to do. Does anyone has suggestions??
Jul 17 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
I have created a combo box with the following properties:

RowSourceType: Value List
RowSource: "0%";"10%";"25%";"36%";"37%"
Bound to column: 1
Limit to List = Yes
Default Value = None
Format: Percent
Decimal Places: 0
Column Count: 0
Control Source: Discount field in a table.

When i load the form and select a value from the combo box, only "0%" appears. I am able to view all other percentages, but when i select any one of them, only 0% appears. I have no clue why is this happening.

Now, if i change the Bound to Column property to 0, then i am able to select the value normally. So, if i select 10% from the list, 10% appears in the combo box.

I am ok to set the Bound to column property to 0, but the problem comes when i need to calculate the discounted price. I have a function that takes the value from this combo box and then calculates the price.

When the Bound to column property is set to 0, the compiler takes the position of the value in the list. So if i select 10%, the cmbDiscount.value displays 2 and not 10%.

I am getting really frustated and don't know what to do. Does anyone has suggestions??
Did you try:
RowSource: 0;10;25;36;37

Nic;o)
Jul 18 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
Did you try:
RowSource: 0;10;25;36;37

Nic;o)
You specified an array of string items rather than numbers.
You can see them, but they have no numerical value when you try to process them.
Jul 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.