Removing blank space on a report

[Jimmy2128]

I have a report that prints an employee roster but it put a blank space between phone and email please see below.
I check all the properties and the query and I cannot make the email address to move-up. Please any suggestions.

Thanks

John Doe
Address1
Address2
City, State Zip
000)000-0000 phone

johndoe@johndoe.com

 

[ZmrAbdulla]

Try something like this

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtEmail = "" Then Cancel= True 
End Sub

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[traingamer]

Check the properties for your phone text box. Make sure 'Can shrink' is enabled. (I'm guessing that 'can grow' IS enabled for the phone.) You may also have spaces in the phone number making it wrap - it could be any number of things. You could also try making the phone text box wider to see if that takes care of it.

good luck

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill