Text box appears selected

[Guest]

Thanks in advance!

When I open my Tabbed form in form view, the text in my first text box on
each tab appears selected. If i click in the box, it will unselect, of
course, but if I return to that tab the text appears selected again.

How can I prevent this from happening?

Stilla

 

[fredg]

Thanks in advance!

When I open my Tabbed form in form view, the text in my first text box on
each tab appears selected. If i click in the box, it will unselect, of
course, but if I return to that tab the text appears selected again.

How can I prevent this from happening?

Stilla

Look up the SelStart property in VBA help:
Code the Enter event of the control:

Me![ControlName].SelStart = Len(Me![ControlName])
The cursor will appear at the end of the field.

 

[Guest]

Thanks Fredg! Worked like a charm where there was text in the text box.
HOWEVER, when the text box was empty I get a "Run-Time Error 13: Type
Mismatch"

Any ideas?

Thanks in advance!

When I open my Tabbed form in form view, the text in my first text box on
each tab appears selected. If i click in the box, it will unselect, of
course, but if I return to that tab the text appears selected again.

How can I prevent this from happening?

Stilla

Look up the SelStart property in VBA help:
Code the Enter event of the control:

Me![ControlName].SelStart = Len(Me![ControlName])
The cursor will appear at the end of the field.

 

[fredg]

Thanks Fredg! Worked like a charm where there was text in the text box.
HOWEVER, when the text box was empty I get a "Run-Time Error 13: Type
Mismatch"

Any ideas?

Thanks in advance!

When I open my Tabbed form in form view, the text in my first text box on
each tab appears selected. If i click in the box, it will unselect, of
course, but if I return to that tab the text appears selected again.

How can I prevent this from happening?

Stilla

Look up the SelStart property in VBA help:
Code the Enter event of the control:

Me![ControlName].SelStart = Len(Me![ControlName])
The cursor will appear at the end of the field.

Test for whether there is data in the field first.
Change that code to:

If Not IsNull(Me![ControlName]) then
Me![ControlName].SelStart = Len(Me![ControlName])
End If

 

[Guest]

Thanks! Your last piece of code, plus an "End If" piece at the end did the
trick!!

Thanks Fredg! Worked like a charm where there was text in the text box.
HOWEVER, when the text box was empty I get a "Run-Time Error 13: Type
Mismatch"

Any ideas?

On Mon, 24 Jul 2006 12:34:02 -0700, Stilla wrote:

Thanks in advance!

When I open my Tabbed form in form view, the text in my first text box on
each tab appears selected. If i click in the box, it will unselect, of
course, but if I return to that tab the text appears selected again.

How can I prevent this from happening?

Stilla

Look up the SelStart property in VBA help:
Code the Enter event of the control:

Me![ControlName].SelStart = Len(Me![ControlName])
The cursor will appear at the end of the field.

Test for whether there is data in the field first.
Change that code to:

If Not IsNull(Me![ControlName]) then
Me![ControlName].SelStart = Len(Me![ControlName])
End If