Hi,

I have a report which out puts anumber of fields from the db. However some of these may occasionally be blank. Does anyone know how to remove the label for the corresponding blank textbox? And secondly remove the blank space left by an empty textbox?

Thanks David

you could probsably use the format event to hide the label if the data was missing. Depending on the type of form you may need to use a naming convention to find the label, because you can;t directly find the label for a given control,

you can use the shrink and grow properties of controls to close up space where appropriate, but it depends on the overall page layout.