Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-17-2001, 03:28 PM   #1
HavingABlondeMoment
Guest
 
Posts: n/a
Delete lines when empty

Hi everyone,

I'm currently trying to get away from Paradox 5.0 and start using Access 97. Neither program am I sufficiently adept at but I can figure out most anything with some guidance *grin*

I have a ratebook with 10 available descripton fields. Field 1 will always have something in it, however fields 2 through 10 may or may not.

In Paradox you click on the field and select "Delete When Empty" (when you are in Report Design).

Does anyone know the equivilent in Access? I've seen mention of CanGrow/Shrink (both of which are set to yes, and still didn't work) and I've seen what I think is criteria, but I don't know how to specify criteria in anything other than query.

Eagerly awaiting your response, I'm *NOT* going to do this in Paradox and making the boss understand that is becoming a problem because he wants his ratebook NOW!


  Reply With Quote
Old 08-17-2001, 04:00 PM   #2
pcs
Senior Member
 
pcs's Avatar
 
Join Date: May 2001
Location: USA,Indiana,Technology Backwater
Posts: 398
Thanks: 0
Thanked 0 Times in 0 Posts
pcs
if your report is formatted like this:
fld1 fld2 fld3 fld4 fld5, etc.
the can grow/shrink will not work. it works only vertically.
like:
fld1
fld2
fld3
fld4

if you need to do it across the page, i would suggest creating a new field that is a concatenation of your 10 fields. fld1 + fld 2 + fld3, etc. you will need to deal with null values to make this work. (see NZ function in help)

hth,
al



[This message has been edited by pcs (edited 08-17-2001).]
pcs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 12:26 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World