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?
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
>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?
>
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
>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
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?
"sparks"
news:pki9h3tht55lv52cedmktvvedq4cvcumtt@4ax.com...
> 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?
>
>
A value list for the combo box could be as follows
1;"Caucasian";2;"Hispanic";1;"1=Caucasian";2;"2=Hispanic"
Hide the 1st column.
Hey this looks great to me...will have to check with the higher ups
(analysis) and see if they can use it.
thanks for the tip
On Tue, 16 Oct 2007 12:29:39 -0500, "paii, Ron"
>
>"sparks"
>news:pki9h3tht55lv52cedmktvvedq4cvcumtt@4ax.com...
>> 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?
>>
>>
>
>A value list for the combo box could be as follows
>
>1;"Caucasian";2;"Hispanic";1;"1=Caucasian";2;"2=Hispanic"
>
>Hide the 1st column.
>
maybe bind it to col 3 and put something like this
1;"Caucasian";"Caucasian";2;"Hispanic";"Hispanic";1;"1=Cauca sian";"Caucasian";2;"2=Hispanic";"Hispanic"
that way I get what I want in the table as well :)
thanks again
On Tue, 16 Oct 2007 12:29:39 -0500, "paii, Ron"
>
>"sparks"
>news:pki9h3tht55lv52cedmktvvedq4cvcumtt@4ax.com...
>> 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?
>>
>>
>
>A value list for the combo box could be as follows
>
>1;"Caucasian";2;"Hispanic";1;"1=Caucasian";2;"2=Hispanic"
>
>Hide the 1st column.
>
Sorry I was reading and didn't even notice that I was reading this
wrong.
I only need 2 columns store column 1 in the table DOH
On Tue, 16 Oct 2007 18:57:10 GMT, sparks
>maybe bind it to col 3 and put something like this
>
>1;"Caucasian";"Caucasian";2;"Hispanic";"Hispanic";1;"1=Cauc asian";"Caucasian";2;"2=Hispanic";"Hispanic"
>
>that way I get what I want in the table as well :)
>
>thanks again
>
>
>On Tue, 16 Oct 2007 12:29:39 -0500, "paii, Ron"
>
>>
>>"sparks"
>>news:pki9h3tht55lv52cedmktvvedq4cvcumtt@4ax.com...
>>> 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?
>>>
>>>
>>
>>A value list for the combo box could be as follows
>>
>>1;"Caucasian";2;"Hispanic";1;"1=Caucasian";2;"2=Hispanic"
>>
>>Hide the 1st column.
>>