combo box multi columns

[sparks]

This should be easy to do...well I thought so

a combo box that needs mult entry types.

if the columns are something like this

1 Caucasian
2 Hispanic
3 African American
make it so that you can type 1 or C 2 or H 3 or A
and then store the text entry into the table

can you get a combo box to accept both columns in entry
or would you do this in code?

[sparks]

I did want to say that when I was listing C H A that was the auto
complete that works in combobox input.

They also just want to display the text and not the numbers on the
form.

I can see 123 or CHA but not both for input unless I do it in code but
it seems that access should allow for both columns ....ok thinking
more what if both columns had text or numbers this would not work.
so it should be code...correct ?
On Tue, 16 Oct 2007 14:31:34 GMT, sparks <js******@swbell.netwrote:

>This should be easy to do...well I thought so

a combo box that needs mult entry types.

if the columns are something like this

1 Caucasian
2 Hispanic
3 African American
make it so that you can type 1 or C 2 or H 3 or A
and then store the text entry into the table

can you get a combo box to accept both columns in entry
or would you do this in code?

[fredg]

On Tue, 16 Oct 2007 14:31:34 GMT, sparks wrote:

This should be easy to do...well I thought so

a combo box that needs mult entry types.

if the columns are something like this

1 Caucasian
2 Hispanic
3 African American

make it so that you can type 1 or C 2 or H 3 or A
and then store the text entry into the table

can you get a combo box to accept both columns in entry
or would you do this in code?

No. A combo will only accept an entry in the first visible column, so
if Column 1 is the first visible column you can only enter a 1,2, or
3. If you hide that number column, then you can only enter the text
value.
If it's the text value you wish to store, then set the bound column of
the Combo to 2 and set it's control source to whatever the table's
text datatype field is.

If you only wish to store the Text value, why are you even including
the number column in the combo box?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[sparks]

>If you only wish to store the Text value, why are you even including
the number column in the combo box?

well the people have the form set up as 1=Caucasian 2= Hispanic...etc

so why can't we enter 1 or C

we get this kind of thing all the time, then on 1=male 2=female
ok we always enter M or F.

go figure...I think that some of the people get it and some don't and
just want to hold a form up to the screen and somehow it flows into
the database. WHY do I have to enter it on each person, shouldn't it
know?

LOL

I thought about something like
for 1 or c or C

If KeyAscii = 49 Or KeyAscii = 97 Or KeyAscii = 65 Then
Me!Race.Column(0) = 1

but since you can't set a value it won't work.

On Tue, 16 Oct 2007 08:03:54 -0700, fredg <fg******@example.invalid>
wrote:

>On Tue, 16 Oct 2007 14:31:34 GMT, sparks wrote:

>This should be easy to do...well I thought so

a combo box that needs mult entry types.

if the columns are something like this

1 Caucasian
2 Hispanic
3 African American

make it so that you can type 1 or C 2 or H 3 or A
and then store the text entry into the table

can you get a combo box to accept both columns in entry
or would you do this in code?

No. A combo will only accept an entry in the first visible column, so
if Column 1 is the first visible column you can only enter a 1,2, or
3. If you hide that number column, then you can only enter the text
value.
If it's the text value you wish to store, then set the bound column of
the Combo to 2 and set it's control source to whatever the table's
text datatype field is.

If you only wish to store the Text value, why are you even including
the number column in the combo box?