[AccessD] Insert a new line in an expression?

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