Re: Select all when control gets focus

Thank you for your reply Crystal,

You are correct for my band aid fix. It is better to set the control to null
rather than a ZLS.

Nice piece of work on the General code to be called from any unbound control
for ID lookup.

So with your reply I gather trying to highlight the control data when
entering the control by clicking, tabbing or enter key is not possible?

Here is the main reason why I'm trying to accomplish this endeavor. The
formatted and unbound combobox is an ID lookup on a text Phone field. Data
is stored as digit characters only, i.e. without the parentheses, hyphen or
spaces. This so that the users can enter the relevant data quickly and have
a bit more structured data, but mostly for the speed and is formatted so they
can easily see what they have entered. I have code for on the change event
that replaces the rowsource to match as if the auto expand property is
functioning.

To give the users piece of mind after a successful lookup or a "not in the
list" I would like to retain the typed information from the combobox so they
can verify (even after the message box for "not in the list" comes up with
their data) that that was what they typed. Also for the next lookup entry
(this form stays open until all customer invoices for the prior day have been
entered) a F2 type highlight of the combobox as soon as it has focus would be
ideal to get around the phone mask, particularly when clicked into and would
solve both issues.

An easy answer would be to teach (and I have tried) the users just to use the
F2 key but unfortunately I have one old dog that will not learn new tricks.

Hopefully the above information is discernable,

Thanks again and Woof Woof,

Bill


strive4peace wrote:
Hi Bill,

it just seems to me that you should do

me.combo_controlname = Null
as soon as whatever should happen with the information is successful.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200702/1

.