Automatic Carriage return in memo feild after button click

[sdel_nevo]

Hi Guys



I have a form called "WorkorderDetails" that when opened is not editable this form has a button called "EditComment" that when clicked unlocks the "comments" box and then moves the focus to the comments box so that users can add additional details.

this works really well, but what I would like to do is this

when the button is clicked unlock the comments box then move the focus to the comments box and then move the cursor to the top of the comments box, then create a new Carriage return so that additional text is always written top to bottom.

is this possible?

the comments box is a memo field

Steve

[orange]

I would recommend a slightly different set up. Have a Comments table that allowed multiple records(comments). This way you could include CommentDate, CommentBy, CommentText fields and relate these to whatever record you need. Each comment would be individually accessible/retrievable.

You should opt for WorkDetails ----->Comments ( a 1 to Many relationship)

I do not think your approach of multiple comments in 1 field would be flexible. You can add a vbCRLF to any text for formatting, but I would suggest it is not a good strategy.

[sdel_nevo]

Hi Orange

many thanks for getting back

that's a much better idea, not sure why I didn't think of that so will go down that route
many thanks again


Steve