Need a textbox to display the percent of steps completed on a form.

[ResearchRN]

I'm enrolling medical centers in a new multi-center database. There are a number of steps that must be completed before the center is enrolled in the project. I have a form that serves as a checklist. I want the textbox at the bottom of the form to display the percentage of steps completed. I guess you would have to count the number of fields on the form that are filled in, but I don't know how to do it.

Thanks.

[June7]

In VBA, something like:

Me.textbox = 0
If Not IsNull(Me!field1) Then Me.textbox= Me.textbox + 1
If Not IsNull(Me!Field2) Then Me.textbox = Me.textbox + 1
...

The real trick is figuring out what event to put code into.

How many fields are involved? An expression in textbox could be:

=IIf(IsNull([field1]),0,1) + IIf(IsNull([field2]),0,1) + IIf(IsNull([field3]),0,1)