1) Jump to beginning of field 2) Expand combo box

J

jhunter

=====
ISSUE
=====
1) I'll got a form I type a lot in (I use "tab" to go from field to
field). Many of the fields are pre-populated. When it goes to a field,
the entire field is SELECTED (which is what I want 90% of the time).
How can I setup a key (maybe a function key) that will place the cursor
at the beginning (or end) of the field (so I don't have to take my
hands off the keyboard)?

2) One of my fields is a combo box. How can I set it to expand WHEN I
TAB TO IT (as opposed to when I start typing)?


==========
BACKGROUND
==========
O/S = WinXP Pro
Patches Installed

Software = Access 2000
Patches Installed


=========
Thanks!!!
THE END
=========
 
T

Thomas Winkler

1) I'll got a form I type a lot in (I use "tab" to go from field to
field). Many of the fields are pre-populated. When it goes to a field,
the entire field is SELECTED (which is what I want 90% of the time).
How can I setup a key (maybe a function key) that will place the cursor
at the beginning (or end) of the field (so I don't have to take my
hands off the keyboard)?
Pos1

2) One of my fields is a combo box. How can I set it to expand WHEN I
TAB TO IT (as opposed to when I start typing)?
Click to expand...

private sub combobox_GotFocus
combobox.dropdown
end sub

HTH

Thomas
 
S

Sokan33

Pos #1
Go to property of your textbox and do the following:
click Event tab,
click On Got Focus event
click the build button ...
click Code Builder and then click OK

Insert the following code:
Me.txtMyTextBox.SelLength = Me.txtMyTextBox.SelStart

substite my txtTextBox with the name of your textbox.
 
H

Harvey Thompson

1) I'll got a form I type a lot in (I use "tab" to go from field to
field). Many of the fields are pre-populated. When it goes to a field,
the entire field is SELECTED (which is what I want 90% of the time).
How can I setup a key (maybe a function key) that will place the
cursor at the beginning (or end) of the field (so I don't have to
take my hands off the keyboard)?

2)
Click to expand...

jhunter,

It's already there. F2 toggles between 'select all' and 'go to end."
 
Top