Invisible textboxes on subform

[Robert]

I have a form which is used as a subform. When I set the visible property
of a textbox to No, the textbox is still visible. Why?

Robert

[pietlinden]

if you're doing this from your main form, you have to make sure you're
referencing the subform controls correctly.

http://www.mvps.org/access/forms/frm0031.htm

[Robert]

No, I was just trying to set the property on the subform in design view.
<pi********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

if you're doing this from your main form, you have to make sure you're
referencing the subform controls correctly.

http://www.mvps.org/access/forms/frm0031.htm

[Sebastian]

If 'DefaultView' of the subform is set to 'Datasheet" then you have to
use the the 'ColumnHidden' property of the textbox control to make it
invisible or visible at runtime.

Sebastian

[Robert]

Where is this property, Sebastian? I can't find it.

"Sebastian" <gr********@artel.ro> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

If 'DefaultView' of the subform is set to 'Datasheet" then you have to
use the the 'ColumnHidden' property of the textbox control to make it
invisible or visible at runtime.

Sebastian

[Sebastian]

ColumnHidden property is not available in design view.
If you just want to hide or unhide a textbox and leave it that way then
you can set the ColumnHidden property by clicking Hide Columns or
Unhide Columns on the Format menu in Datasheet view. However if you
want to dinamically change this property at runtime then you have to
use VBA. (me.SomeTextBoxName.ColumnHidden = true or false).
Check the help for ColumnHidden property.

Sebastian

[Robert]

Found it. Thanks.
"Sebastian" <gr********@artel.ro> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

ColumnHidden property is not available in design view.
If you just want to hide or unhide a textbox and leave it that way then
you can set the ColumnHidden property by clicking Hide Columns or
Unhide Columns on the Format menu in Datasheet view. However if you
want to dinamically change this property at runtime then you have to
use VBA. (me.SomeTextBoxName.ColumnHidden = true or false).
Check the help for ColumnHidden property.

Sebastian