Controlling insertion point on a form

[Catherine M]

I would like to have the insertion point change depending
on the field tabbed to, i.e. placed at the beginning of
some fields but have other fields selected. It does not
appear that this is possible on a field by field basis, or
even for individual forms. The setting is done under
Tools, Options, Keyboard and seems to apply to everything
in Access once it is set. Do I have to create macros to
control this and call them when entering each field?

Catherine

 

[fredg]

I would like to have the insertion point change depending
on the field tabbed to, i.e. placed at the beginning of
some fields but have other fields selected. It does not
appear that this is possible on a field by field basis, or
even for individual forms. The setting is done under
Tools, Options, Keyboard and seems to apply to everything
in Access once it is set. Do I have to create macros to
control this and call them when entering each field?

Catherine

Look up the SelStart and SelLength properties in Access Help.

In the control's Enter event:
Before the first character...
[SomeControl].SelStart = 0
or
After the last character
[SomeControl].SelStart = Len([SomeControl])

 

[Catherine M]

-----Original Message-----

I would like to have the insertion point change depending
on the field tabbed to, i.e. placed at the beginning of
some fields but have other fields selected. It does not
appear that this is possible on a field by field basis, or
even for individual forms. The setting is done under
Tools, Options, Keyboard and seems to apply to everything
in Access once it is set. Do I have to create macros to
control this and call them when entering each field?

Catherine

Look up the SelStart and SelLength properties in Access Help.

In the control's Enter event:
Before the first character...
[SomeControl].SelStart = 0
or
After the last character
[SomeControl].SelStart = Len([SomeControl])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

Thanks for your help. I took me awhile to get back to
this project.
Catherine