Limited space in combo box!!!

[thefroggy]

Hi everyone,

I'm using access 2000 and I'm currently creating a form to simplify current paper process.
I have a form with several combo boxes where all of them are linked with SLQ query.
When someone will introduce new material they have to report some safety issue regarding the material and different option can be picked up.

The problem I have is that some of the options in the SLQ queries are more than 100 characters long sentences and when selected and added in the combo box, The following remark appears: " The field is too small to accept the amount of data you attempted to add" even if more spaces are available in the box.

Is anyone knows how to increase the quantity of character in combo box?

Many thanks,

Stephane

 

[LittleSmudge]

It's not the size of the COMBO BOX it is the size of the text field in the underlying table that the combo box is bound to.





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[thefroggy]

Little smudge

Thanks for the reply, I have already modified the field size in the table and increased it to "150", and it works in the table, but I still can't have more than 50 carateres in the combo box after that...

Do you know if combo boxes have limited spaces on there own?

Stephane

 

[LittleSmudge]

No they do not.


If Limit to list is set to Yes then the limitation of what the combo box will display will be what's already in the row source.

Otherwise it will display ADT and will store up to the size limit of the underlying field.

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[nimarii]

you might want to try changing the field type to memo instead of text.

if it doesn't work, you might want to check to see that the table is linked correctly to the combo-box?

hope this helps!

 

[LittleSmudge]

One more idea froggy.

Is your database a front end / back end split.

If you change field size in the back end, the front end does not get to see the changes until you close it down and re-open it ( or go through the exercise of refreshing the links. )

This might be why the change doesn't appear to have done any good.


( But be now you'll probobly have closed it down anyway . )


'ope-that-'elps.






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.