[AccessD] Insert a new line in an expression?

Mark,
Now that's slick!  Thanks for the tip.
Tina

Mark A Matte wrote:
> That being the case...why not set the textbox height to 0 and the property 'CanGrow' to true...and this should give you the desired effect.  I use this all of the time for addresses on postcards and letters.  If the PO box doesn't exist...the line won't appear on the report .
>  
> Let me know if you have questions.  I can even send a sample offline come Monday if need be.
>  
> Thanks,
>  
> Mark A. Matte> Date: Sat, 3 Nov 2007 15:25:50 -0400> From: tinanfields at torchlake.com> To: accessd at databaseadvisors.com> Subject: Re: [AccessD] Insert a new line in an expression?> > Hi Susan,> It's in a textbox control on a report. Does that have the same > constraints as a query?> Thanks for thinking about it for me.> Tina> > Susan Harkins wrote:> >> When I write:> >> =Trim( Iif( [MailAddr1] Is Not Null, [MailAddr1] & vbCrLf, "")& > >> [MailAddr2])> >> Access treats vbCrLf not as a constant but as a parameter.> >> > >> > =====Is this in a query expression? I don't think you can use vb constants > > in a query expression.> >> > Susan H. > >> > > -- > AccessD mailing list> AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com
> _________________________________________________________________
> Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare!
> http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews
>