[AccessD] Label vs text box and carriage return issue.

Cr and LF are two different characters.  You need them both to throw a line the text box.

Use either   vbCRLF     or       Chr$(13) & CHR$(10)


-- 
Stuart


On 2 Jun 2008 at 11:40, Darryl Collins wrote:

> 
> 
> Hey guys and gals.
> 
> Whilst most of you are mooching about on Sunday, it is Monday here in
> Deep South Oz (urrrrgh) and I am trying to get a report to behave. 
> 
> I am using Labels which I want to populate with a list returned from a
> query.  Now I have the query working great, and I have the data being
> populated into the labels, but I cannot get the damn carriage return
> working correctly.  I have tried Chr(10), vbCr and vbLf.  All work in
> that they put in a Carriage return character, but it doesn't actually
> write to the label with carriage returns functioning - still write the
> data in a single line. 
> 
> I want:
> Alpha
> Beta
> Gamma
> Delta
> 
> NOT:
> "Alpha Beta Gamma Delta" (with the carriage return char showing in the spaces).
> 
> ' ------------- Code Start -------------------
> 
> ... yada yada yadah...
>     
>                     If (rsActClone.RecordCount) > 0 Then
>                         sProgText = ""
>                         Do While Not rsActClone.EOF
>                             n = n + 1
>                             If n > rsActClone.RecordCount Then
>                                 Exit Do
>                             End If
>                             
>                             sProgText = rsActClone!ProgName.Value
>                             sANS = sANS & sProgText & vbLf '<-- THIS BIT HERE IS BOTHERSOME
>                             rsActClone.MoveNext
>                         Loop
>                     End If
>                 End If
>                 
> ... and so on....
> 
> ' ------------ End Code ----------------------
> 
> This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com