How to force carriage return between strings?

[divardo]

Hi,

I am outputting a field in an access report in a vertical format. I would like it to go across the screen from left to right but all alone the same horizontal line. I know this could be done with forcing a carriage return after each string but I'm not sure how to go about this. Anybody have any ideas? Thanks.

 

[Scooterbug]

Adding a chr(10) will do the trick

 

[SOS]

Adding a chr(10) will do the trick

Actually, technically you should add a Chr(13) & Chr(10) to it.

13 is the Carriage Return
10 is the line feed

 

[MSAccessRookie]

Actually, technically you should add a Chr(13) & Chr(10) to it.

13 is the Carriage Return
10 is the line feed

Don't forget vbCrLf if you are using VB as the method.

 

[SOS]

Don't forget vbCrLf if you are using VB as the method.

Yes, you can use vbCrLf which is a constant that is basically the same as having the Chr(13) & Chr(10). So, in code I will use the constant name and in queries or control sources you have to use the CHR method.