AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question QUESTION: Hi,
I created a report on Access 2007 and I am having a formatting issue. Is there anyway to get rid of a vertical space? For instance I have to have a 'Program Description' field, however not everything I am working with has a program description and for those that don't Access leaves a space for where it should go. Is there any way to get rid of this space?
ANSWER: Set the Can Shrink property of the control to Yes.
However, if you are doing a columnar report that might look like this:
Date: 6/30/09
Program Description:
Program Cost: $1000
Because the label exists, the Can Shrink property will have no affect. You might have also do something like this in the On Format event of the detail band:
If IsNull([ProgramDescription]) Then
Me.ProgramDescriptionLabel.Caption = Null
End If
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: It is a columnar report. Right now I am using
IIf ([Program Description] is not null, [Program Description], null)
This just leaves a blank line so it looks like
Date: 6/30/09
Program Cost: $1000
Can I get rid of the space?
ANSWER: Did you try what I said?
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: Okay. I believe I did try to do what you said. I entered it in exactly as you typed above but the program said there is a Syntax error. This is my first time using access and I've been pretty much teaching myself. So I am assuming I could be entering it in wrong but I entered exactly as above and it did not work.
Answer You can't enter it EXACTLY as I gave you. Because I have no idea what the object names of your controls are. ProgramDescription and ProgramDescriptionLabel are control names. You have to use the correct names for the control and label. Also, did you set the Can Shrink and Grow Property?
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
