Need Help !!!

[shriver]

I am working a Microsoft Access project and coming to the end. The problem I am having is that my boss wants me to have a nice report. However, in the report if they do not give me a fax number, or a website name then that label infront of it should not show. I can do this in Visual Basic I know it, but I do not know how to manipulate reports only forms. If anyone can help please e-mail me back at chrisgatorsuck@hotmail.com. Thanks.

 

[Carmen]

In the On Format event of the section of the report your field is in put your code, something like this:

If IsNull(Me.MyField) = True then
Me.MyLabel.Visible = False
Else
Me.MyLabel.Visible = True
End If



HTH
Carmen

 

[chewy]

can you post a pic of the report how it currently is and point out what you would like to change?

 

[shriver]

YEAH

I have to leave work now but I'll do it tomorrow. Thanks for everyone help on this.

Chris

 

[shriver]

Here's the screenshot.... Let me know if you guys know how to take off the extra lables that do not have information for them. For example, ALT Phone and E-mail address...

Chris

 

[KevinM]

Where's the screenshot

 

[shriver]

Screenshot.....

I put it on last time but it didn't work... hopefully this is it.

 

[HockeyNut]

Erm, nope.

Maybe 3rd time lucky then Shriver?

 

[shriver]

I TRIED !!

I have browse for it in the attachement and for some reason it still isn't working. I saved the screen shot as a Bit Map too. I have no clue. If someone wants to give me their e-mail address I will sent it to them but I am about to tell my boss that there is no way I can do it.

Chris

 

[HockeyNut]

After you've browsed to it you then need to click add, it doesn't automatically add it, so you need to do this.