Access Access 2003 Carriage Return Insertion

N

Norbert O'Brien

Joined
Jul 11, 2017
Messages
1
Reaction score
0
I know this is probably covered somewhere, but I have spent a long time trying to find help on what would seem to be a very simple matter. I am having to use an old version of Access where I have created a DB. On the main form there is a Memo field where comments are entered. Via a command button I am trying to insert a new line at the top of the box pushing the text down and inserting the date, leaving the cursor at the end of the date for the user to write.

I have used the following but can not get the new line to work, existing text is deleted. I don't want entry or exit functions involved.

Private Sub Insert_Comment_Click()

Me.Comments.Locked = False
Me.Comments.SetFocus
Me.Comments.SelStart = 0
Me.Comments.SelLength = 0
Me.Comments = Chr(13)
Me.Comments = Date


End Sub

Any help would be appreciated! Novice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Focus on a subform object and using .SelStart 2
SelStart trouble related to subForm 1
Carriage return 4
Access 2 Digit year in Access Text Box 3
VB Coding Assistance 2
VISIO from Excel VBA 0
Replace Carriage Return ASCII Character in Memo Field 3
Access Sub form opens before the main form in MS Access 0

Top