I'm trying to prepopulate certain fields on a form when opening using a button.
I have it working for single line entries but I have a rich textbox which I would like different info on different line.
I've tried both Chr(13) & Chr(10) and VbCrLf but all the text is still on the one line. From what I've read this is because it's a rich text box? One the form is opened I can manually go to a new line with the ENTER key as that is set in properties.
Any help greatly appreciated. Below is just one of the ways I've tried that only puts the info on 1 line.
------------
Dim D As String
D = "SITE NAME:" & vbCrLf & "ON-SITE CONTACT:"
DoCmd.OpenForm "Case Details", acNormal, , , acFormAdd
Forms![Case Details]![Description] = D
------------
Bookmarks