Access 07 Combo/list box

[healthguy]

Hello everyone. I'm desperately in need of help. You see i have pretty much taught access (2007) to myself, and have come across an issue i need troubleshooted.

The problem i have is that i've created a combo box (not through using event builder and syntax, instead through the "general" "lookup" tabs and properties menu) and i have a list of 270 job titles i want to appear in the dropdown. However after i go back into my table and edit the field to add more titles they dont save. It seems as there is a limit to the list...about 80 titles or so. At any rate, can anyone assist me to override this lock, and input all the 270 job titles i have? Thank you in advance. Ciao

 

[dkinley]

I don't see why that would prevent an issue .. unless it's List Rows property of the combo box or some corruption with the box itself.

If you are going to have a combo box with gabillions of entries, might want to take a look at this also ...

http://allenbrowne.com/ser-32.html

-dK

 

[healthguy]

Thanks dk, but i already checked that page out and couldn't make sense of it.

This is what i have in my Lookup tab:

Display Control: Combobox
Row Source type: Value list
Row source: all my job titles
Bound column: 1
Column count: 1
Column heads: No
Column width: 1"
List rows: 16
List width: Auto
Limit to list: Yes
Allow value list edits: Yes
List Items edit form: (left blank)
Show only row source values: No


I basically copied and pasted this field from a template into my table, and from there went into the table and just edited by list. What do i do? Thanks.

 

[dkinley]

Oh, you are doing your entry directly into the table - I was thinking from a form.

Hmm.

Hmmmmmmm.

 

[georgedwilkinson]

To overcome the 80 limit, put all of your entries into a table and base your combo-box data source off of the table.

Do not use a combo-box to enter data directly in a table. Use a form.

 

[dkinley]

This is what i have in my Lookup tab.

I assumed healthguy was directly entering into the table.

I only have read about 25 item limit and I think that is referring to static input. I am not sure of any limitations per se.; hence possible corruption with the combo box itself - but if from table ... no idea here.

-dK

 

[healthguy]

thanks...but i have created a table with all the fields of my choosing, afterwhich i've created a form with that field (the combobox) as a drop down option in the form.

Example of my form which populates my table associated to the form:

John Smith would enter his name in the field called "name"

then i would want john smith to select from a drop down menu of 270 job titles of what he does. This is my problem i can't get all my job titles to pop up on the same dropdown list. is there any other approach you think i can take for John smith to be able to select his respected job title from some sort of list.

thanks

HG

 

[georgedwilkinson]

Sounds like you're pretty early in the development cycle and I'd love to help.

Can you post your DB here?

How To Upload A Database To The Forum