Enter "some" text into combo box with code?

[ShyGuy]

Is it possible to use code to enter some text into a combo box and
then have the cursor placed at the end of the text for more imput?

[PC Datasheet]

Dim SomeText As String
SomeText = "Some Text You Want To Enter"
Me!MyTextBox = SomeText
Me!MyTextBox.SelStart = Len(SomeText) + 1

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"ShyGuy" <sh****@shytown.com> wrote in message
news:14********************************@4ax.com...

Is it possible to use code to enter some text into a combo box and
then have the cursor placed at the end of the text for more imput?

[ShyGuy]

Thanks for the reply. This worked great on a text box, but I need it
to work on a combo box.

On Tue, 18 Jan 2005 01:35:18 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Dim SomeText As String
SomeText = "Some Text You Want To Enter"
Me!MyTextBox = SomeText
Me!MyTextBox.SelStart = Len(SomeText) + 1

[PC Datasheet]

Works the same -- Just change MyTextBox in the code to MyCombobox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"ShyGuy" <sh****@shytown.com> wrote in message
news:q1********************************@4ax.com...

Thanks for the reply. This worked great on a text box, but I need it
to work on a combo box.

On Tue, 18 Jan 2005 01:35:18 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Dim SomeText As String
SomeText = "Some Text You Want To Enter"
Me!MyTextBox = SomeText
Me!MyTextBox.SelStart = Len(SomeText) + 1

[ShyGuy]

My Bad. I tried it on a new form and changed the !'s to .'s and it
worked. It still doesn't work on my for so I'll have to look for
what's different.

Thanks very much for your help.

On Tue, 18 Jan 2005 04:24:09 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

>Dim SomeText As String
>SomeText = "Some Text You Want To Enter"
>Me!MyTextBox = SomeText
>Me!MyTextBox.SelStart = Len(SomeText) + 1

[ShyGuy]

The combo box I am working on has three columns. I am pretty sure
that this is why it isn't working. Is it possible to get this to work
in this situation?

On Tue, 18 Jan 2005 01:04:55 -0500, ShyGuy <sh****@shytown.com> wrote:

My Bad. I tried it on a new form and changed the !'s to .'s and it
worked. It still doesn't work on my for so I'll have to look for
what's different.

Thanks very much for your help.

On Tue, 18 Jan 2005 04:24:09 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

>Dim SomeText As String
>SomeText = "Some Text You Want To Enter"
>Me!MyTextBox = SomeText
>Me!MyTextBox.SelStart = Len(SomeText) + 1

[PC Datasheet]

Although you see three columns, the combobox still only has one value. Look
at the row source property and the bound column property to see if the bound
column is text.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"ShyGuy" <sh****@shytown.com> wrote in message
news:0d********************************@4ax.com...

The combo box I am working on has three columns. I am pretty sure
that this is why it isn't working. Is it possible to get this to work
in this situation?

On Tue, 18 Jan 2005 01:04:55 -0500, ShyGuy <sh****@shytown.com> wrote:

My Bad. I tried it on a new form and changed the !'s to .'s and it
worked. It still doesn't work on my for so I'll have to look for
what's different.

Thanks very much for your help.

On Tue, 18 Jan 2005 04:24:09 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

>Dim SomeText As String
>SomeText = "Some Text You Want To Enter"
>Me!MyTextBox = SomeText
>Me!MyTextBox.SelStart = Len(SomeText) + 1

[ShyGuy]

This first column is an index key, and it is an autonumber. The bound
column is 1, but I'm not sure if that is the first column or the
second. For some reason I am thinking that the column numbers start
with 0? The other two are text fields. I enter text to search in
the second column and the third is used to reference if there are
duplicates in the second column. So, if the columns start with 0 then
I am searching for a match in the bound column which is a text field.

On Tue, 18 Jan 2005 14:21:08 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Although you see three columns, the combobox still only has one value. Look
at the row source property and the bound column property to see if the bound
column is text.

[PC Datasheet]

Point 1 --- For the purpose of Bound Column, the columns are numbered 1 to
whatever in your rowsource. So, with the bound column set to 1, the value of
your combobox is the value of the autonumber field. If the combobox is a
bound field and you look at the table where your data on the form is being
saved, you should see numbers.
Point 2 --- The fact that the rowsource of your combobox has an autonumber
says that your combobox is drawing from a set of data already recorded in
the database. In which case it is very unclear why you want to
programatically enter text into the combobox. Please explain.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"ShyGuy" <sh****@shytown.com> wrote in message
news:j3********************************@4ax.com...

This first column is an index key, and it is an autonumber. The bound
column is 1, but I'm not sure if that is the first column or the
second. For some reason I am thinking that the column numbers start
with 0? The other two are text fields. I enter text to search in
the second column and the third is used to reference if there are
duplicates in the second column. So, if the columns start with 0 then
I am searching for a match in the bound column which is a text field.

On Tue, 18 Jan 2005 14:21:08 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Although you see three columns, the combobox still only has one value. Lookat the row source property and the bound column property to see if the boundcolumn is text.