forcing a carride return for access 2003 text box

have several records that i want to place a retun between in some vba code
this is what i am trying to use but it does not work
alldata = alldata & Chr(10) & Chr(13) & rst![Comment]
the same as a return will not give a carridge return in my text box, but if i use cntl return it does give me the carridge return so what i need is the asscii code that i can change in here
alldata = alldata &   ****     Chr(10)   **** & Chr(13) & rst![Comment]
that willl add the equiv to holding down the cnt and return key at thse same time
thanks in advance
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
This should work - reversing the order of 13 and 10

alldata = alldata & Chr(13) & Chr(10) & rst![Comment]

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
You could also use the VBA constant vbCrLf

alldata = alldata & vbCrLf & rst![Comment]

sydneyguyAuthor Commented:
thanks for that they both work and will use them in different positions thanks for the input perrrrfect
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.