Bobby Heid
bheid at appdevgrp.com
Tue Jun 24 06:09:21 CDT 2003
And if this does not work, then you might want to try and build the string with the vbCRLF or Chr$(13) & Chr$(10) combo then put that into the textbox. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Tuesday, June 24, 2003 12:06 AM To: Judy Johnson; accessd at databaseadvisors.com Subject: Re: [AccessD] Report Layout On 23 Jun 2003 at 23:50, Judy Johnson wrote: > > > I'm working in Access 97 and am stumped - > I need to force a new line in some concatenated output on a report. > I've tried chr(10) and chr(13) and all I get on the report are > littlesquares wherever the chr() was in the string - and my text > contines as a long, word wrapped string. > You need both of the above, in the correct order. Either use "Chr$(13) & Chr$(10)" or the built in constant vbCRLF > I have an unbound text field on the report (txtActivity). The text > I'm trying to enter is working fine, except no line breaks. > > Thanks. > Judy -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com