J
Joanne
I have this coding (which was given to me by MVP\ in this forum,
thank you very much) in a txtbox that has '-B/O' as it's default value
Private Sub TxtPoNo_AfterUpdate()
Const strAddText As String = "-B/O"
If Right(Me.txtPoNo.Value, Len(strAddText)) <> strAddText Then _
Me.txtPoNo.Value = Me.txtPoNo.Value & strAddText
End Sub
The problem is that when I tab into the control, the default value is
highlighted, so when I start to type the numbers to preceed the
default value, the default value gets deleted.
Could someone please tell me how to 'de-select' the default value on
entering the control so it doesn't disappear on me?
Thanks for your time
Joanne
thank you very much) in a txtbox that has '-B/O' as it's default value
Private Sub TxtPoNo_AfterUpdate()
Const strAddText As String = "-B/O"
If Right(Me.txtPoNo.Value, Len(strAddText)) <> strAddText Then _
Me.txtPoNo.Value = Me.txtPoNo.Value & strAddText
End Sub
The problem is that when I tab into the control, the default value is
highlighted, so when I start to type the numbers to preceed the
default value, the default value gets deleted.
Could someone please tell me how to 'de-select' the default value on
entering the control so it doesn't disappear on me?
Thanks for your time
Joanne