Tina Norris Fields
tinanfields at torchlake.com
Tue Dec 9 06:07:50 CST 2008
Thanks Stuart. Darn! I'll use the Chr$ stuff instead. TNF Stuart McLachlan wrote: > You've found one of the places where you can't use intrinsic constants. > > Replace vbCRLF with Chr$(13) & Chr$(10). > > > On 8 Dec 2008 at 15:02, Tina Norris Fields wrote: > > >> Hi, >> >> I'm trying to craft a report that lists the addresses of members of an >> organization. Some people have year-round addresses; some people have >> summer and winter addresses. The list is supposed to be something like >> this: (this whole message is set up in fixed width font to make the >> addresses all line up on tabs) >> >> John Anderson 123 Main St (231) 555-2323 >> MyTown, MI 49676 janderson at someisp.net >> Winter 465 Wisteria Ln (416) 555-1776 >> OtherTown, OH 48332 Zone: A - Clearwater Twp >> >> Of course many members will not have a winter address, so I want to >> display that portion only if the condition is met that the address >> season is "WIN" >> Some addresses will have only street addresses, some will have only PO >> Box addresses, some will have both - so there's an Addr1 field and an >> Addr2 field. The CanShrink property will take care of getting rid of >> the blank lines if either Addr1 or Addr2 is empty. I had thought I >> would like to put the full address into an Iif expression, concatenating >> everything together with carriage returns and line feeds where >> appropriate, but that is not working - if I put in VbCrLf in my >> expression, Access treats is as a parameter and asks for the value. Darn! >> >> It would be really helpful to me if anyone can direct me to examples of >> this sort of report. >> >> TIA >> >> TNF >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > >