hide a text box that has calculation in it..

[stephendeloach via AccessMonster.com]

Is there a way I can hide a text box in a subform that hold a calculation? I
only need the calculation so show in the report. I have tried to set the
Visible to No and it still shows in the subform..

 

[Dirk Goldgar]

In

Is there a way I can hide a text box in a subform that hold a
calculation? I only need the calculation so show in the report. I
have tried to set the Visible to No and it still shows in the
subform..

Is your subform perhaps being displayed in datasheet view? The Visible
property only applies in form view (single form or continuous form). If
that's the problem, I'd recommend just using continuous form view
instead possibly modifying the format so that it looks like a datasheet
if that's what you prefer. If you want to keep it as a datasheet,
though, I believe it's the ColumnHidden property you have to set.

 

[stephendeloach via AccessMonster.com]

Works great now! Thanks

Is your subform perhaps being displayed in datasheet view? The Visible
property only applies in form view (single form or continuous form). If
that's the problem, I'd recommend just using continuous form view
instead possibly modifying the format so that it looks like a datasheet
if that's what you prefer. If you want to keep it as a datasheet,
though, I believe it's the ColumnHidden property you have to set.