Hide fields

[Garry Jones]

I have a database with several hundred records in. On a few of these
records I need an extra field. I want to hide this field on all other
records.

I used "visible=false" and a fixed command button to change the field to
"visible = true" for when the field is needed.

However, what I have failed to do is to get the field to dissapear on
the next record. When I scroll to the next record the now visible field
is still visible. What I need is to turn the field "on" if the record
exists and "off" if it doesn't. What's the simplest way?

Help appreciated.

Garry Jones
Sweden

 

[Van T. Dinh]

I think you are referring to Control(s) on the Form???

If that the case, use the Form_Current Event to make the Control(s) visible
/ inbvisible depending on the values of the relevant Fields in the current
Record.