Selecting field contents when TAB in it

[Bogdan Zamfir]

Hi,

When users TAB to a field, I want it not to select all field content, but
instead go to either begin or end of the field. This because sometimes user
TAB to a field then type something by mistake, by this loosing old content
from the field

I know Access have setting for Behavior setting field, but this seems global
to Access, not to application, so no matter if I change this setting, if I
run app on a PC where Access have this setting as Select Entire field, it
will still select.

I tried with sendkeys left / right arrow, or home / end, but this don't
seems to work.

Any other idea?

Thanks for answers

[R.A.Balder]

Re: Selecting field contents when TAB in it

No solution, except to tell the users, that they can press ESC, and cancel
their entry right until the moment they leave the record they are entering
into.
But most likely there is possible coding for this.

Brgds
Rolfern

"Bogdan Zamfir" <bzamfir@despam med.com> wrote in message
news:c2a78g$1ql ujc$1@ID-218369.news.uni-berlin.de...[color=blue]
> Hi,
>
> When users TAB to a field, I want it not to select all field content, but
> instead go to either begin or end of the field. This because sometimes[/color]
user[color=blue]
> TAB to a field then type something by mistake, by this loosing old content
> from the field
>
> I know Access have setting for Behavior setting field, but this seems[/color]
global[color=blue]
> to Access, not to application, so no matter if I change this setting, if I
> run app on a PC where Access have this setting as Select Entire field, it
> will still select.
>
> I tried with sendkeys left / right arrow, or home / end, but this don't
> seems to work.
>
> Any other idea?
>
> Thanks for answers
>
>[/color]

[Bob Quintal]

Re: Selecting field contents when TAB in it

"R.A.Balder " <R_A_BALDER@xho tmail.com> wrote in
news:4n72c.4441 7$BD3.8238492@j uliett.dax.net:
[color=blue]
> No solution, except to tell the users, that they can press
> ESC, and cancel their entry right until the moment they leave
> the record they are entering into.
> But most likely there is possible coding for this.
>
> Brgds
> Rolfern
>[/color]

Very simple code.


const BSelectAll = 0
const BStartOfField = 1
const BEndOfField = 2
dim iPreviousbehavi or as integer

previousbehavio r = getoption("beha vior entering field")
setoption("beha vior entering field", BEndOfField)
....
'do what you will,
...
setoption("beha vior entering field", iPreviousBehavi or)

Bob Quintal



[color=blue]
> "Bogdan Zamfir" <bzamfir@despam med.com> wrote in message
> news:c2a78g$1ql ujc$1@ID-218369.news.uni-berlin.de...[color=green]
>> Hi,
>>
>> When users TAB to a field, I want it not to select all field
>> content, but instead go to either begin or end of the field.
>> This because sometimes[/color]
> user[color=green]
>> TAB to a field then type something by mistake, by this
>> loosing old content from the field
>>
>> I know Access have setting for Behavior setting field, but
>> this seems[/color]
> global[color=green]
>> to Access, not to application, so no matter if I change this
>> setting, if I run app on a PC where Access have this setting
>> as Select Entire field, it will still select.
>>
>> I tried with sendkeys left / right arrow, or home / end, but
>> this don't seems to work.
>>
>> Any other idea?
>>
>> Thanks for answers
>>
>>[/color]
>
>
>[/color]