Cursor not at start of field

[Guest]

I have created a form with approximately 15 fields. When I tab through the fields on the form the cursor goes to the start of the field, when the field is a text field. When it is a date or email it goes to the end of the field

When I click the cursor with the mouse in the text field, the cursor goes anywhere on the field, such as middle or end. How can I force the cursor in text fields to go the beginning of the field when using the mouse

Thanks

Ronnie

 

[Rick B]

This was just answered on Monday. Do a search.

The answer was...

In the On Enter event of the field put
Me!fieldname.SelStart = Me!fieldname.SelStart



I have created a form with approximately 15 fields. When I tab through the
fields on the form the cursor goes to the start of the field, when the field
is a text field. When it is a date or email it goes to the end of the
field.

When I click the cursor with the mouse in the text field, the cursor goes
anywhere on the field, such as middle or end. How can I force the cursor in
text fields to go the beginning of the field when using the mouse?

Thanks

Ronnie

 

[Rick B]

Unfortunately, I was just going by what someone else had posted. I have it
on my list to do in my own database

What you need to do is make the onenter event an event procedure, then in
the code enter the following...

Private Sub SomeField_Enter()
Me!SomeField.SelStart = 0
End Sub




Hope that helps.

Rick Bear

Thanks Rick, I have tried this and still no joy. The syntax I used was

Me!County.Selstart = Me!County.Selstart

where county is the name of the field. I also tried this on another field
and still no joy. They are definately in the On Entry event of the field

Any other ideals