Column Count

[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!

 

[John Vinson]

Is it possible to get the column/field count of a
subform.

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!

 

[Reggie]

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!

 

[John Vinson]

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!

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