Conditional Label Line (Access 2000)

Topic

New Reply

How do you create a conditional line for a Label Report?
There are occasions when a fourth line is required, such as a %someone.
I have tried a IIF(IsNull…) as suggested from Help; however, this is producing an input prompt of the non-null field.
An better solution would be greatly appreciated.
Ray A.

Reply | Quote

Replies

The source table (your address list?) should include a field for this fourth line. Normally it would be blank (null). Include this field on your report. If the value for the fourth line field is null it will just appear as blank. It sounds like this is what you want. You can also set the CanShrink property for this control on your report to Yes which will collapse this line when it’s Null. This shouldn’t affect the alignment of your labels if your columns and rows are set up correctly in Page Setup (e.g., as set up by the Labels report wizard). Also, as long as the CanShrink property of the Detail section is set to “No” your label height won’t vary.

Hope this helps.

Reply | Quote