list box option

M

Miguel Vivar

I have created controls in my form with the option "listbox". The list of
options that appears in my "listbox" are short in length except for one of
them that is quite large. I increased the column width length in order to fit
the large option. However, now that I want to choose that specific option
when I enter data, access does not let me choose it. Is there a way to fix
this problem?
Miguel
 
A

Al Camp

Miguel,
"Quite large" and "does not let me choose it" doesn't tell us much.
Do you get an error message?
What is that error message?

Can't be sure, but it sounds like the length of the long listbox choice
exceeds the length of the field it is bound to.

Increase the length of the field bound to the listbox via your table design,
or... consider finding some meaningful way to shorten that one long choice.
There should be some way to abbreviate it.
 
M

Miguel Vivar

Al:
Yes, the lenght of the long listbox choice exceeds the length of the field
it is bound to. What I did is I increased the lenght of the field in the
table design. However, when this option is chosen when I enter the data I get
the message "the field is too small to accept the small amount of data you
attempted to add" even when I increased the lenght of the field. I'm not sure
if there is a solution to that, and if there is please let me know.
Miguel
 
A

Al Camp

What is the length of the long data you're trying to insert into the field?
What is the length of the field in the table design?
 
M

Miguel Vivar

Al:
The length of the long data is of 3.7" (column width).
The length of the field name is 50 characters.
I hope this helps
Miguel
 
A

Al Camp

Miguel,
The length of the long data is of 3.7" (column width).
Click to expand...
You don't measure DATA length in inches!!
You measure the "length" of data by the number of characters in the
string.

If your "long" listbox selection is 35 characters long, the field in your
table, bound to that listbox must be defined as AT LEAST 35 in length also.
If your "long" listbox selection is 75 characters long, the field in your
table, bound to that listbox must be defined as AT LEAST 75 in length also.

Example...
"This is a sample data entry"
The length of that example string is 32. The length of the field that would
hold that data must be defined in the table design as at least 32.
 
Top