How to reduce blanks between two fields in a report??

[h2mhd]

Hi

i have made a report named quotation, the we use to make quotation to a client. So the forms as different sections:

- distribution
- circuits
- exits
- heating
- etc

all field in the form as a check field, so we check just the fields we needs. since that my idea is good i think but i have two problems :

1- when i leave fields unchecked the is a blank space in the report that is really not cute
2- i want to call a page break so that the text is not cut in two if it's possible

your help would be very nice

Thanks a lot

 

[dhookom]

Sounds like an issue with your table structure if you have multiple yes/no fields.

Depending on your structure, I would consider a normalizing union query to use in your record source.

Duane
Hook'D on Access
MS Access MVP