Different conditional formating for each record displayed by a form

[erel joffe]

Hi,

I want to loop through my records and display/print them in form view.
For each record I want to display only the fields that hold data.
Null values change between fields and are null,0 or 999.
I have written a code that sets the Field.Height to 0 when the field is empty.
The problem is that when I run the code it works only for the current record in the form while I want it to reaplly the view for each record.
I am sure this is very basic.
Could anyone tell me how to make the code run for each record in the form.

Thank you

[Stewart Ross]

Hi erel. If you mean that you want to alter the way fields are displayed in continuous form view it is by no means a simple or basic task. Access uses just one set of controls on the form's detail section, and this single set of controls is repeated for each record displayed in continuous view, so it is impossible to resize just one instance of a control without the change rippling to all other instances visible on-screen at the time.

The more usual method of hiding a control is simply to set its Visible property false under code control. Again this will work fine in single-form view but not in continuous view.

Please confirm which view you are meaning, as the difference is quite fundamental to what you can really do using the On Current event to make record-by-record changes to what is displayed.

-Stewart

[erel joffe]

Thanks for the prompt reply.
First I must state that I have no experience in VBA and I am using my limited knowledge in Java to get by. I am a physician runnig a study and I use form to display records of different subjects in a study. Each record is different and I need to print out a report in form layout only of the not-null fields.
I guess this a continous form.
I read of the recordset command but I am not quite sure how to use it with the form.
I will go read about the on current event and see if it works.
If you or anyone could direct me to an example of a similar code I can take it from there.
Thanks and all the best
E