Access Access 2007 Can Grow Not Working

Joined
Aug 9, 2011
Messages
1
Reaction score
0
I have a simple report in Access 2007 with that is pulling address/email information. For longer emails, rather than wrapping to a new line, it cuts off the "name" I tag to it to identify which parents it corresponds to. If the email is long, I'd want the name to wrap to the next line rather than run off the margin. Here is my control:

IIf(IsNull([Parent 1 Email]),"",Chr(13)+Chr(10)+[Parent 1 Email]+" "+"("+Right([Parent 1 First Name],(Len([Parent 1 First Name])-InStrRev([Parent 1 First Name]," ")))+")")+IIf(IsNull([Parent 2 Email]),"",Chr(13)+Chr(10)+[Parent 2 Email]+" "+"("+Right([Parent 2 First Name],(Len([Parent 2 First Name])-InStrRev([Parent 2 First Name]," ")))+")")

thanks!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top