Heya!
I feel I'm beating an old horse to death with this question but I
can't get around the problem.
I want to update a text field on a form with a string from a VB
module. I need enter/linefeeds in the string.
I've tried:
Chr(10) & Chr(13)
Chr(13) & Chr(10
vbnewline
vbcrlf
none of which seem to work.
I've set the properties for the text box to [Enter Key Behavior] =
'New Line In Field' and [Can Grow] = 'yes'.
At the moment, my code looks like this:
celsql = celsql _
& "Program: " & encname _
& vbCrLf _
& vbCrLf _
& "Start Time: " & sttim _
& vbCrLf _
& "Participants: " & numpart _
& vbCrLf _
& "Confirmed by Curator: " & cbc _
& vbCrLf _
& "Client: " & clntnm _
& vbCrLf _
& "Contact: " & cntct _
& vbCrLf _
& vbCrLf
Forms(frm)(bts) = celsql
If I toss this string into a [MsgBox], it comes out fine. It's just
something about the text field...
I'm working in MSAccess 2007, but need it backwards compatible to
2003.
I'd really appreciate any advice.
Cheers,
KG