Unwanted "Selection" with open form

I have just added a list box to a form to ensure standard data entry
of a salutation for members. Mr; Mrs; Ms etc.

Now when the form is opened the list box fields and the first tab stop
field are selected. This is unwanted.

Because I always fail to express myself correctly I have shown a
screen capture he

http://www.rotary9790.org.au/test/test2.html

Thanks,

Robin Chapple

Robin Chapple wrote:
I have just added a list box to a form to ensure standard data entry
of a salutation for members. Mr; Mrs; Ms etc.

Now when the form is opened the list box fields and the first tab stop
field are selected. This is unwanted.

Because I always fail to express myself correctly I have shown a
screen capture he

The highlighting in the ListBox is indicating the row currently "chosen"
from the list. The highlighting of the LastName control is becasue it
currently has Focus.

These are two different things.

What exactly do you want (or not want?). It is a bit unusual to use a
ListBox only one row high like you are which I believe is confusing the
issue.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Tue, 29 Aug 2006 07:37:42 +1000, Robin Chapple wrote:

I have just added a list box to a form to ensure standard data entry
of a salutation for members. Mr; Mrs; Ms etc.

Now when the form is opened the list box fields and the first tab stop
field are selected. This is unwanted.

Because I always fail to express myself correctly I have shown a
screen capture he

http://www.rotary9790.org.au/test/test2.html

Thanks,

Robin Chapple

What control do you want to go to when the form opens?
If you wish to go to a particular control when the form opens, then
code the form's Load event:
[ControlName].SetFocus

If you would like to go to that control each time you navigate to a
new record, then use the Form's Current event instead.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Mon, 28 Aug 2006 21:46:03 GMT, "Rick Brandt"
wrote:

Robin Chapple wrote:
I have just added a list box to a form to ensure standard data entry
of a salutation for members. Mr; Mrs; Ms etc.

Now when the form is opened the list box fields and the first tab stop
field are selected. This is unwanted.

Because I always fail to express myself correctly I have shown a
screen capture he

The highlighting in the ListBox is indicating the row currently "chosen"
from the list. The highlighting of the LastName control is becasue it
currently has Focus.

These are two different things.

What exactly do you want (or not want?). It is a bit unusual to use a
ListBox only one row high like you are which I believe is confusing the
issue.

Your comment made me rethink to options and I have now used a value
list instead of the ListBox and all is well,

Many thanks.

Robin Chapple

On Mon, 28 Aug 2006 14:52:54 -0700, fredg
wrote:

On Tue, 29 Aug 2006 07:37:42 +1000, Robin Chapple wrote:

I have just added a list box to a form to ensure standard data entry
of a salutation for members. Mr; Mrs; Ms etc.

Now when the form is opened the list box fields and the first tab stop
field are selected. This is unwanted.

Because I always fail to express myself correctly I have shown a
screen capture he

http://www.rotary9790.org.au/test/test2.html

Thanks,

Robin Chapple

What control do you want to go to when the form opens?
If you wish to go to a particular control when the form opens, then
code the form's Load event:
[ControlName].SetFocus

If you would like to go to that control each time you navigate to a
new record, then use the Form's Current event instead.

Thanks Fred, that has helped with the rest of the problem./

Robin