Combobox problem in MSACCESS

[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.

 

[Ken Snell]

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

 

[Guest]

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.

 

[Ken Snell]

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.

 

[Ken Snell]

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.

 

[Guest]

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.

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.

 

[Ken Snell]

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>

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.

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.

 

[Guest]

Format property is blank for the combobox.

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>

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.

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.

 

[Ken Snell]

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>

Format property is blank for the combobox.

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>

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.


:

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.