More Blank Fields 2

[webcats2]

Hi,

I have a database for a questionnaire that has 18 sections. Each section has a comments field. I have a report that prints out the 18 comments fields but I don't want to print out the fields that are empty.

I read and used some of the suggestions in the "blank fields" thread. I now have another problem. I set the properties for "Can Shrink" "Can Grow" to yes. This got rid of the fields. The problem is now, if I have comments in Section 1 and the rest are empty until section 10 there is a gap between comments section 1 and comments section 10. I have determined that this is caused by there actually being something in place of the empty fields even though the empty fields are not visible.

I hope I am making sense.

Thanks.

 

[SgtJarrow]

Do any of the controls touch? Are you hiding the labels if the field is Null? These are two reasons....

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[webcats2]

Hi Robert,

Yes the controls are touching. When I move them apart the gap is even bigger.

I deleted the labels and added the this to the control source: ="Fieldname Comments: "+[Fieldname Comments] which pops the "Fieldname Comments:" in the beginning of the text box. I thought the lables would be a problem.

Thanks.

 

[nschultz]

I had a similar problem with a report that has sub-reports. When there was nothing in a given sub-report it would leave a blank space. I solved the problem by setting the Can Grow to Yes and on the main report making the sub-reports 0.01 inches high.

There was a gap but it took 10 sub-reports in a row that were empty to make a 0.1 inch space. I do not know if it will work with fields but you might try it.

Norm

 

[SgtJarrow]

If any controls on the same horizontal line, the line cannot be skrunk properly. You should set them to be as close as possible without actually touching. Then ensure the fields are set to can grow and can shrink. Also make sure the detail section of the report is set to can grow and can shrink. Fnally, you need to check each control and if the control is empty, you need to hide the appropriate label also. If you can get away without the labels I would recommend deleting them....

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[CosmoKramer]

Could you modify your query to only return records whose comments fields are populated??

Hoc nomen meum verum non est.

 

[SgtJarrow]

oh....nice CosmoKramer.....I should have thought of that myself.

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[webcats2]

Thanks for your help!

 

[obli]

CosmoKramer
"Could you modify your query to only return records whose comments fields are populated??"

Ummm...I have the same needs but can't figure out how to modify my query. Any help would be appreciated.

 

[EgWeb]

Try:

Open the query in design view and under the field there is a criteria cell. Put something like <> &quot;&quot; or Is Not Null.