Recent content by jeeper987

I am creating a report from a query. The report has two columns and many rows. The first colum is the label fields and the second is the data or text for each category. For some reason the the label fields will not not wrap the text. If the label is to long for the width of the column, it...

yes I set it on the detail section and for each field individually and it still leaves some blank white space

My report hides fields when they are null using this code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.MyField.Visible = Not IsNull(Me.MyField) end Sub I have enabled the CanShrink for each field in the report, but it still leaves some blank space where the excluded...

also, is there a way to delete the empty space where the field would have been or to move the next visible field up into its place so that there will not be any gaps in the report.

Works great Rich, Now, is there a way I can apply this to all fields in the report, without having to do it for each field individually. Thanks

If I put "is not null" in the fields, will it not exclude the entire record. I just want to exclude one field out of a record. The report will have name, address, phone, fax, email as the fields. If the person does not have fax number, I do not want the report to put the caption "fax" or a...

I want to create a report from a query. Many of the records have null values. I would like for the report to exclude the field name and the space where the value would be. In other words, I would like for it to look like there is not a field there. I need this in order to make the report...