Why is cursor in certain field when opening Form?

[tompru1215]

I have a Form designed and each time you reenter the Form to view a
previously inputed record, the cursor is always in a certain field and all
the text in that field is highlighted - and this field happens to be a memo
field with a paragraph or more of data - a lot to lose. Why is this occuring
- can the cursor be set to appear in a certain field in the Form so I can
avoid this?

 

[Armen Stein]

Open the form in design view, and set the Tab Order for the controls.

In Access 2007, it's on the Arrage tab of the Form design Tools ribbon
(Control Layout section.)

In earlier versions, it's on the View menu.

Also, if you don't want the whole text to be selected when tabbing
into the field, in Access 2003, change your setting for Behavior
Entering Field on Tools | Options | Keyboard. Careful though, that
setting applies to your whole Access install, not just this database.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[tompru1215]

Also, if you don't want the whole text to be selected when tabbing
into the field, in Access 2003, change your setting for Behavior
Entering Field on Tools | Options | Keyboard. Careful though, that
setting applies to your whole Access install, not just this database.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

Great - thank you both - I will check these suggestions out tonight.

 

[beno]