Row Source Type in Combo Box

G

Guest

My Row Source type is set to Value List, and my row source is Revenue, Sales
Tax, Receipts. The combo box is storing the index number (0, 1, 2) in the
table instead of the actual text value (Revenue, Sales Tax, Receipts). How
do I get it to store the actual text value? The data type in the source
table is set to Text.
 
O

OfficeDev18 via AccessMonster.com

Kirk,

Check the Bound Column property of your combo. It should be between 1 and 3.

Sam
 
M

Marshall Barton

Kirk said:
My Row Source type is set to Value List, and my row source is Revenue, Sales
Tax, Receipts. The combo box is storing the index number (0, 1, 2) in the
table instead of the actual text value (Revenue, Sales Tax, Receipts). How
do I get it to store the actual text value? The data type in the source
table is set to Text.
Click to expand...

It sound like you have the combo box's BoundColumn set to 0.
It should be set to 1.
 
J

jleckrone

In the properties of the combobox, under Format, how many columns are
there in Column Count? It should be 1. You could also change the
bound column to 2 if the column count is more than one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Textbox.tag properties to keep values 0
Create a yes no message on a command button on click 0
Combo box returning wrong value 2
Access Control on subform / combo box requesting parameter 0
Need combo box to refresh when moving to new record 2017 1
Combo Box Synchronizing Problem 1
Combo Box 1
combo box - bound column 2

Top