Disappearing textbox on subform (1 Viewer)

S

solnajeff

Registered User.

Local time

Today, 03:36

Joined

May 22, 2007

Messages

33

• Jul 14, 2019

• #1

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

..forever waiting... waiting for jellybean!

Local time

Today, 08:36

Joined

May 7, 2009

Messages

19,231

• Jul 14, 2019

• #2

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

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 17:36

Joined

Aug 30, 2003

Messages

36,124

• Jul 14, 2019

• #3

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

 

S

solnajeff

Registered User.

Local time

Today, 03:36

Joined

May 22, 2007

Messages

33

• Jul 16, 2019

• #4

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