Custom Report

[rhay]

Here is my situation..I need to create a report based off of 1 table..but some records don't have data in some fields and some do. I need this report to omit the fields for each record where there is no data in the field.

Example:

I have 2 records..each has the field name of "mission" , 1 record has data in that field the other doesn't. I don't want the report to show the field of the record that doesn't have any data and to display the field of the record that does.

Is this possible?

Thanks,

Robert

 

[rhay]

Pat,

Thanks!!! It worked great!

However...

3 things?

1. Is there a way when it omits that particular field on a record, that it shifts the other fields up so there isn't a space where the excluded one was.

2. In the code when I use a field name that has a space in it I get a compile error that says Expected list separator or ) ??

3. Can I use this to omit more then one field? and if so, how?

Also, thanks for your quick answer..I have been banging my head and researching an answer for this for the last week...Just found this site tonight and it has already been worth it's while.


Robert

 

[rhay]

Thanks again Pat..it's working perfectly!!

 

[rhay]

Pat,

Couple questions here.

I don't see anything on the label where I can select Shrink and Grow, I only have that option on the data box.

That being said, I can use this method, but where there are several fields that are hidden there is a gap between the field before and after. Is there a way to eliminate this gap?

Robert

 

[DFISHER]

I am following the same procedures and they have worked well up to the point where the changes of the text boxes.
Yes, I too have spaces. I have text boxes that will display nothing if a field <1. The field was created to bring in data for the header.
Is there anyway to get rid of the space. I've tried the shrinking technique without success.
Thanks, this is driving me nuts!

 

[rhay]

I know this is an Access forum, however, can this also be applied to an html document? I.E. hiding an empty data field?

I have an ASP page that calls up records into a table but as in the report example above not all fields will have data. Anyone know of a way to hide this in HTML?

Robert