Search results

Thanks for trying. I can't get it to work. My IT is gone for the day so I will have to try on Monday.

Same error. I just don't get it . I am probably missing something very obvious.I even opened a brand new report and tried your suggestion and I still get the same error message: "There was an error compiling this function. The VB module contains a syntax error. check the code then recompile." HUH?

It all works fine wihen I don't try to put in a line break. Its the line break that messing it up. =[Employee Name]+[Home Street Address]+[Home City State Zip]+[Home Phone]+[Cell Phone]+[Job Title] returns: Dr. Duck Don1562 Pluto Rd, Saint Louis, MO 62236-2816(123) 456-7897(123)...

ARGH I have been working on this all day. I checked the spaces, no luck. I did know about the + and the null values which is why I was going to use it. I just want to get the line break to work. Any other ideas? I am still getting the error message.

Thanks, I tried that and am getting an error message about syntax. Here is what I put. =[Employee Name]&Chr(13)&Chr(10)& [Home Street Address]&[Home City State Zip]&[Home Phone]&[Cell Phone]&[Job Title]

I am trying to put together an employee directory. Some employees want home information kept private so I set the report up like this below so if some infomraiton is missing, their won't be an empty space. I can not figure out how to get it to line break after Name, Home Street Address, and...