This must be right, but why?

[Middlemarch]

Form has one textbox.

Private Sub Form_Open(Cancel As Integer)
    txtEComment = "why is this highlighted"
End Sub

Forecolor is black, backcolor is white. But it's reversed showing selected or Highlit until the textbox is clicked. Why is that?
Should it not just open and show the text in the colors assigned?

[June7]

This textbox gets focus when form opens?

[Middlemarch]

Not sure if you're asking me or telling me, but seems you'd not want it to be selected, but where to move the focus if there's no other control ?
Can you set Focus just to the Form ?

[isladogs]

Yes it is because the textbox has focus. Setting the focus to the form itself won't help.
However you can move the cursor to the start or end of the textbox to solve this

Private Sub Form_load()

Me.Text0 = "test"

Me.Text0.SetFocus
Me.Text0.SelStart = 0 'move cursor to start
'Me.Text0.SelStart=Len(Me.Text0) 'move cursor to end
End Sub

BTW I sent you a PM a few weeks ago (30 Oct) but didn't get a reply. Can you have a look please

[Middlemarch]

Hi @Colin, that stops the text beig selcted nut the cursor at the start doesn't seem right eother. If anywhere at the end of text is more logical.
Access sure is strange at times, ok so a Form with one control gives focus to that contoel. but why select the text as well ?
And if it has focus, why is the command Me.Text0.SetFocus needed ?
Sorry for missing your PM but there's nothing in my inbox.

[isladogs]

You have to explicitly set the focus to the control to use SelStart
It may be that Access is actually setting the focus to the form but as the form only has the one control, perhaps that means the textbox is selected without actually having focus????

Apologies- the PM was sent to another forum member with a fairly similar name - not to you!

[davegri]

When I don't want anything visible selected when a form opens, I create a dummy text box, txtDummy, set its height and width to zero and its tabindex to 0.
After form opens, you have to tab or click with mouse to see the cursor.

[Middlemarch]

@davegri I vaguely remember that now, but thought it a hack and there must be something better.
Something in properties would have been helpful.
But if it's the only way....

[davegri]

@davegri I vaguely remember that now, but thought it a hack and there must be something better.
Something in properties would have been helpful.
But if it's the only way....

If you get other solutions that you like better, you then have other choices.

[isladogs]

It can also be done without code from Access Options...Client Settings..,Behavior entering field.
There are 3 choices - Select entire field, go to start of field, go to end of field. Only the first choice will highlight the textbox contents.
This achieves the same result as using SelStart BUT it is a per user setting