Column Count

  • Thread starter Thread starter Reggie
  • Start date Start date
R

Reggie

Thanks in advance. Is it possible to get the column/field count of a
subform. I'm trying to get a count of the visible columns in the subform.
I'm able to get the count of fields of the recordset of the subform, but not
having luck getting the count after columns are hidden. I always get the
total number of fields. Thanks!
 
Is it possible to get the column/field count of a
subform.
Click to expand...

That's tough... given that if you use Datasheet view, a user can
shrink a column down to zero width or even down to a hundredth of an
inch ("visible" but functionally not visible). That's one reason I use
Continuous Forms in preference; users can't hide their own data from
themselves as easily!
 
That's my preference too, but in this case there's 20 fields and the users
like hiding/showing columns so that only info they currently need is
displayed. They then want to send the displayed info(visible fields) to a
report and I'm trying to fill the fields on the report similar to basing a
report on a crosstab query where the number of fields can change. Thanks
for your reply John!
 
That's my preference too, but in this case there's 20 fields and the users
like hiding/showing columns so that only info they currently need is
displayed. They then want to send the displayed info(visible fields) to a
report and I'm trying to fill the fields on the report similar to basing a
report on a crosstab query where the number of fields can change. Thanks
for your reply John!
Click to expand...

Groannn...

Sorry I can't be more help. I don't know any way to loop through the
fields. You might want to check with Steven Lebans, this sounds like
the kind of wizardry he's famous for: http://www.lebans.com/toc.htm
 
Back
Top