S
Steve Albert
I am using Access 2003. I would like to use vba code so that when a user
clicks in an empty text box, a bullet (Alt-0149) is inserted first and then
the user can enter text. When the user then hits the enter key, another
bullet is inserted and they can type more text. If there is text already in
the text box, then clicking inside the box will not add an initial bullet,
but if you hit enter, a new bullet will be inserted.
I was able to program a bullet to be inserted when you click in the text
box, but can't get further. Any help would be appreciated. - Steve
Private Sub ActionsComp1_Enter()
If Len(Trim([ActionsComp1])) > 0 Then
Me![ActionsComp1] = [ActionsComp1] + Chr$(13) & Chr(10) & "• "
Else
Me![ActionsComp1] = "• "
End If
End Sub
clicks in an empty text box, a bullet (Alt-0149) is inserted first and then
the user can enter text. When the user then hits the enter key, another
bullet is inserted and they can type more text. If there is text already in
the text box, then clicking inside the box will not add an initial bullet,
but if you hit enter, a new bullet will be inserted.
I was able to program a bullet to be inserted when you click in the text
box, but can't get further. Any help would be appreciated. - Steve
Private Sub ActionsComp1_Enter()
If Len(Trim([ActionsComp1])) > 0 Then
Me![ActionsComp1] = [ActionsComp1] + Chr$(13) & Chr(10) & "• "
Else
Me![ActionsComp1] = "• "
End If
End Sub