Combobox problem in MSACCESS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of the query
populating the combobox, Column Count property of the combo box and Column
Widths (i have mentioned widths for all the columns) property of the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc, tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
 
Is the field to which the combob box is bound formatted to accept the length
of the data in the other columns?
 
I didn't get your question. You mean to say the database field should be
formatted to accept the length of the data in the other columns?? Why do we
need to do so?

Ken Snell said:
Is the field to which the combob box is bound formatted to accept the length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of the query
populating the combobox, Column Count property of the combo box and Column
Widths (i have mentioned widths for all the columns) property of the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc, tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
 
My question is, what is the format of the combo box in the form's design
view? and what is the format of the table's field to which the combo box is
bound? If, for example, the format is text with a character string length of
50, and your values in the other columns exceeds 50, then they'll likely be
truncated because they don't fit into the field's constraints or the combo
box's constraints.

Note that I'm suggesting this because your post doesn't provide info re:
what the characteristics of the query's fields are and what types of data
they contain. This may or may not be the problem.

Can you clarify if the "truncation" is in the display inside the combo box
or is in the dropdown list?
--

Ken Snell
<MS ACCESS MVP>


Ganesh said:
I didn't get your question. You mean to say the database field should be
formatted to accept the length of the data in the other columns?? Why do we
need to do so?

Ken Snell said:
Is the field to which the combob box is bound formatted to accept the length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of the query
populating the combobox, Column Count property of the combo box and Column
Widths (i have mentioned widths for all the columns) property of the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc, tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Is the field internal_org_cd in the table formatted as a numeric format? And
are the following fields formatted as text?
tbl_619_ioc_cd.ioc_parent_cd
tbl_619_ioc_cd.internal_org_cd
tbl_619_ioc_cd.aor_no
tbl_619_ioc_cd.aor_desc
tbl_619_ioc_cd.aor_manager_nm

And are some of the values in these fields all numbers and others a mix of
numbers and letters?

Assuming the above are all true, then the truncated list likely is showing
only the records whose bound column fields are "numeric" in content with no
letters in them. Your first field in the query is a text field (because it's
a concatenated text string), so it also could have the same result.

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
Hi, I don't have any problem in field widths. By truncated list i mean that
if ideally the query (record source) returns 50 rows, the combo box is
showing only 2-3 row.
There is no filter being applied. Please help.


Ken Snell said:
My question is, what is the format of the combo box in the form's design
view? and what is the format of the table's field to which the combo box is
bound? If, for example, the format is text with a character string length of
50, and your values in the other columns exceeds 50, then they'll likely be
truncated because they don't fit into the field's constraints or the combo
box's constraints.

Note that I'm suggesting this because your post doesn't provide info re:
what the characteristics of the query's fields are and what types of data
they contain. This may or may not be the problem.

Can you clarify if the "truncation" is in the display inside the combo box
or is in the dropdown list?
--

Ken Snell
<MS ACCESS MVP>


Ganesh said:
I didn't get your question. You mean to say the database field should be
formatted to accept the length of the data in the other columns?? Why
Click to expand...
do
we
need to do so?

:

Is the field to which the combob box is bound formatted to accept
Click to expand...
the
length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of the
query
populating the combobox, Column Count property of the combo box
Click to expand...
and
Column
Widths (i have mentioned widths for all the columns) property of the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc,
tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
All the fields mentioned below are text only including internal_org_cd. Can't
i have a bound column as text format?
I have seen that when i make bound column property of the combo as 0, it
shows the whole list.


Ken Snell said:
Is the field internal_org_cd in the table formatted as a numeric format? And
are the following fields formatted as text?
tbl_619_ioc_cd.ioc_parent_cd
tbl_619_ioc_cd.internal_org_cd
tbl_619_ioc_cd.aor_no
tbl_619_ioc_cd.aor_desc
tbl_619_ioc_cd.aor_manager_nm

And are some of the values in these fields all numbers and others a mix of
numbers and letters?

Assuming the above are all true, then the truncated list likely is showing
only the records whose bound column fields are "numeric" in content with no
letters in them. Your first field in the query is a text field (because it's
a concatenated text string), so it also could have the same result.

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
Hi, I don't have any problem in field widths. By truncated list i mean that
if ideally the query (record source) returns 50 rows, the combo box is
showing only 2-3 row.
There is no filter being applied. Please help.


Ken Snell said:
My question is, what is the format of the combo box in the form's design
view? and what is the format of the table's field to which the combo box is
bound? If, for example, the format is text with a character string length of
50, and your values in the other columns exceeds 50, then they'll likely be
truncated because they don't fit into the field's constraints or the combo
box's constraints.

Note that I'm suggesting this because your post doesn't provide info re:
what the characteristics of the query's fields are and what types of data
they contain. This may or may not be the problem.

Can you clarify if the "truncation" is in the display inside the combo box
or is in the dropdown list?
--

Ken Snell
<MS ACCESS MVP>


I didn't get your question. You mean to say the database field should be
formatted to accept the length of the data in the other columns?? Why do
we
need to do so?

:

Is the field to which the combob box is bound formatted to accept the
length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of the
query
populating the combobox, Column Count property of the combo box and
Column
Widths (i have mentioned widths for all the columns) property of the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS
aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc,
tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Yes, a text formatted column can be the bound column. The reason I asked
about the numeric format is because, when you set the Bound Column to 0,
ACCESS uses the ListIndex value (which is a Long Integer) as the value of
the combo box.

What is the format of the combo box (Open Properties window while form is in
design view and click on combo box, and then click on Format tab)?

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
All the fields mentioned below are text only including internal_org_cd. Can't
i have a bound column as text format?
I have seen that when i make bound column property of the combo as 0, it
shows the whole list.


Ken Snell said:
Is the field internal_org_cd in the table formatted as a numeric format? And
are the following fields formatted as text?
tbl_619_ioc_cd.ioc_parent_cd
tbl_619_ioc_cd.internal_org_cd
tbl_619_ioc_cd.aor_no
tbl_619_ioc_cd.aor_desc
tbl_619_ioc_cd.aor_manager_nm

And are some of the values in these fields all numbers and others a mix of
numbers and letters?

Assuming the above are all true, then the truncated list likely is showing
only the records whose bound column fields are "numeric" in content with no
letters in them. Your first field in the query is a text field (because it's
a concatenated text string), so it also could have the same result.

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
Hi, I don't have any problem in field widths. By truncated list i mean that
if ideally the query (record source) returns 50 rows, the combo box is
showing only 2-3 row.
There is no filter being applied. Please help.


:

My question is, what is the format of the combo box in the form's design
view? and what is the format of the table's field to which the combo
Click to expand...
box
is
bound? If, for example, the format is text with a character string length of
50, and your values in the other columns exceeds 50, then they'll
Click to expand...
likely
be
truncated because they don't fit into the field's constraints or the combo
box's constraints.

Note that I'm suggesting this because your post doesn't provide info re:
what the characteristics of the query's fields are and what types of data
they contain. This may or may not be the problem.

Can you clarify if the "truncation" is in the display inside the
Click to expand...
combo
box
or is in the dropdown list?
--

Ken Snell
<MS ACCESS MVP>


I didn't get your question. You mean to say the database field
Click to expand...
should
be
formatted to accept the length of the data in the other columns??
Click to expand...
Why
do
we
need to do so?

:

Is the field to which the combob box is bound formatted to
Click to expand...
accept
the
length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column
Click to expand...
count of
the
query
populating the combobox, Column Count property of the combo
Click to expand...
box
and
Column
Widths (i have mentioned widths for all the columns) property
Click to expand...
of
the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS
aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc,
tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Format property is blank for the combobox.

Ken Snell said:
Yes, a text formatted column can be the bound column. The reason I asked
about the numeric format is because, when you set the Bound Column to 0,
ACCESS uses the ListIndex value (which is a Long Integer) as the value of
the combo box.

What is the format of the combo box (Open Properties window while form is in
design view and click on combo box, and then click on Format tab)?

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
All the fields mentioned below are text only including internal_org_cd. Can't
i have a bound column as text format?
I have seen that when i make bound column property of the combo as 0, it
shows the whole list.


Ken Snell said:
Is the field internal_org_cd in the table formatted as a numeric format? And
are the following fields formatted as text?
tbl_619_ioc_cd.ioc_parent_cd
tbl_619_ioc_cd.internal_org_cd
tbl_619_ioc_cd.aor_no
tbl_619_ioc_cd.aor_desc
tbl_619_ioc_cd.aor_manager_nm

And are some of the values in these fields all numbers and others a mix of
numbers and letters?

Assuming the above are all true, then the truncated list likely is showing
only the records whose bound column fields are "numeric" in content with no
letters in them. Your first field in the query is a text field (because it's
a concatenated text string), so it also could have the same result.

--

Ken Snell
<MS ACCESS MVP>

Hi, I don't have any problem in field widths. By truncated list i mean
that
if ideally the query (record source) returns 50 rows, the combo box is
showing only 2-3 row.
There is no filter being applied. Please help.


:

My question is, what is the format of the combo box in the form's design
view? and what is the format of the table's field to which the combo box
is
bound? If, for example, the format is text with a character string
length of
50, and your values in the other columns exceeds 50, then they'll likely
be
truncated because they don't fit into the field's constraints or the
combo
box's constraints.

Note that I'm suggesting this because your post doesn't provide info re:
what the characteristics of the query's fields are and what types of
data
they contain. This may or may not be the problem.

Can you clarify if the "truncation" is in the display inside the combo
box
or is in the dropdown list?
--

Ken Snell
<MS ACCESS MVP>


I didn't get your question. You mean to say the database field should
be
formatted to accept the length of the data in the other columns?? Why
do
we
need to do so?

:

Is the field to which the combob box is bound formatted to accept
the
length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of
the
query
populating the combobox, Column Count property of the combo box
and
Column
Widths (i have mentioned widths for all the columns) property of
the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS
aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc,
tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
A real puzzler!

If you can zip up example of database and email it to me (do it tonite if
possible, as I'll be away from home for almost a week after tomorrow), I'll
take a look. Include instructions about which form and which combo box.

My email address can be gotten by removing this is not real from my reply
email address.

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
Format property is blank for the combobox.

Ken Snell said:
Yes, a text formatted column can be the bound column. The reason I asked
about the numeric format is because, when you set the Bound Column to 0,
ACCESS uses the ListIndex value (which is a Long Integer) as the value of
the combo box.

What is the format of the combo box (Open Properties window while form is in
design view and click on combo box, and then click on Format tab)?

--

Ken Snell
<MS ACCESS MVP>

Ganesh said:
All the fields mentioned below are text only including
Click to expand...
internal_org_cd.
Can't
i have a bound column as text format?
I have seen that when i make bound column property of the combo as 0, it
shows the whole list.


:

Is the field internal_org_cd in the table formatted as a numeric
Click to expand...
format?
And
are the following fields formatted as text?
tbl_619_ioc_cd.ioc_parent_cd
tbl_619_ioc_cd.internal_org_cd
tbl_619_ioc_cd.aor_no
tbl_619_ioc_cd.aor_desc
tbl_619_ioc_cd.aor_manager_nm

And are some of the values in these fields all numbers and others a
Click to expand...
mix
of
numbers and letters?

Assuming the above are all true, then the truncated list likely is showing
only the records whose bound column fields are "numeric" in content
Click to expand...
with
no
letters in them. Your first field in the query is a text field
Click to expand...
(because
it's
a concatenated text string), so it also could have the same result.

--

Ken Snell
<MS ACCESS MVP>

Hi, I don't have any problem in field widths. By truncated list i mean
that
if ideally the query (record source) returns 50 rows, the combo box is
showing only 2-3 row.
There is no filter being applied. Please help.


:

My question is, what is the format of the combo box in the
Click to expand...
form's
design
view? and what is the format of the table's field to which the
Click to expand...
combo
box
is
bound? If, for example, the format is text with a character string
length of
50, and your values in the other columns exceeds 50, then
Click to expand...
they'll
likely
be
truncated because they don't fit into the field's constraints or the
combo
box's constraints.

Note that I'm suggesting this because your post doesn't provide
Click to expand...
info
re:
what the characteristics of the query's fields are and what types of
data
they contain. This may or may not be the problem.

Can you clarify if the "truncation" is in the display inside the combo
box
or is in the dropdown list?
--

Ken Snell
<MS ACCESS MVP>


I didn't get your question. You mean to say the database field should
be
formatted to accept the length of the data in the other
Click to expand...
columns??
Why
do
we
need to do so?

:

Is the field to which the combob box is bound formatted to accept
the
length
of the data in the other columns?

--

Ken Snell
<MS ACCESS MVP>

I have a combobox in one of my access form. I am using a
query to populate the combobox. When i am setting the
BoundColumn property to a nonzero value, i am getting a
truncated list in the combobox. But when i am using
boundcolumn property as 0 or blank, i am getting full list
in the combobox.
As suggested by some programmer i have matched the column count of
the
query
populating the combobox, Column Count property of the
Click to expand...
combo
box
and
Column
Widths (i have mentioned widths for all the columns)
Click to expand...
property
of
the
combobox, But this didn't help. Please help

Here are the information for the combobox:
SQL View of the query: SELECT [aor_no] & " " & [aor_desc] AS
aor_display,
tbl_619_ioc_cd.ioc_parent_cd, tbl_619_ioc_cd.internal_org_cd,
tbl_619_ioc_cd.aor_no, tbl_619_ioc_cd.aor_desc,
tbl_619_ioc_cd.aor_manager_nm
FROM tbl_619_ioc_cd
ORDER BY tbl_619_ioc_cd.aor_no;
Control Source: internal_org_cd
Bound Column: 3
Column Count: 6
Column Widths: 2.5";0";0";0";0";0"
Any pointers to this problem and it's
solution will be highly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top