How to hide fields in form?

[Mascotte]

Hi

I have a form and a subform is linked to it. The subform is in datasheet view. Does anyone know how to hide fields which have null value in the subform?

Thanks

 

[missinglinq]

If you hide fields that have Null values, how do you ever enter data in them? Perhaps a little better explanation is in order.

 

[Mascotte]

Hi missinglinq,

I have a table with more than 100 fields. I have a form and a subform is linked to it. Not all the fields have records in them. so i would like to hide those fields which have no value. Do u think i can be able to do it?

 

[Mascotte]

Can u show me an example of "columnhidden" please?

thanks

 

[marianne]

nope. im wrong. i was thinking of column. yours is field. lol

 

[missinglinq]

Hi missinglinq,

I have a table with more than 100 fields. I have a form and a subform is linked to it. Not all the fields have records in them. so i would like to hide those fields which have no value. Do u think i can be able to do it?

To begin with, a table with 100 fields is almost assuredly not Normalized. Most experienced developers will tell you that no table should have more that 25-30 fields, tops.

Secondly, I suspect that none of the 'fields' have record in them! Records have fields, fields don't have records.

ColumnHidden hides the entire column, not some of the column but not other parts.

 

[WIS]

To begin with, a table with 100 fields is almost assuredly not Normalized. Most experienced developers will tell you that no table should have more that 25-30 fields, tops.

Missingling

What you have said is not strictly correct. I have seen a normalized tbl with nearly 200 flds. Most of these are flds that contain data that needs to be reported every 3 mths to a govt authority (flds are dynamic) so don't need a sub tbl.

 

[marianne]

that is why missingling said "MOST" not ALL

 

[WIS]

that is why missingling said "MOST" not ALL

I was referring to the 1st sentence.

 

[missinglinq]

The first sentence was

"To begin with, a table with 100 fields is almost assuredly not Normalized."

 

[Rabbie]

Missingling

What you have said is not strictly correct. I have seen a normalized tbl with nearly 200 flds. Most of these are flds that contain data that needs to be reported every 3 mths to a govt authority (flds are dynamic) so don't need a sub tbl.

In my experience (25+ years) with databases people who design databases with 100+ field tables that are normalised don't post questions on forums like this.

However People who have unnormalised tables with many fields often post here. Thats why Missinglinq and I react when we see very broad tables.