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!!!
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!!!