Disappearing textbox on subform

[solnajeff]

Hi

I have a problem with a textbox on a subform disappearing when it is empty.

The form has a number of subforms all behaving correctly with empty textboxes. All are set to no for grow/shrink and all properties are set the same on each subform.

The only thing that is different is that the disappearing textbox is linked to a query rather than a table.

Any advice wold be greatly appreciated.

Regards

Jeff

 

[arnelgp]

investigate the parent/child link. do they have same data type.

 

[pbaldy]

Also note the controls on a form or subform will disappear if the form returns no records and doesn't allow new records.

 

[solnajeff]

Hi

Thanks for the advice.

Although there are other subforms that have blank textboxes the subform itself contains data so I assume that is why the border still displays.

Need to think about that

Many thanks

Jeff