Count unbound controls fields with value in

S

Silvio

How do I programmatically count how many control in my form are not null?
All the controls are unbounded. The form has 13 controls. This total will
progress as the user fills in all the required control. In short, I have a
progress bar (13 means 100%) that will count the progress until all the
controls are totally filled and ready to be saved.
 
B

bhicks11 via AccessMonster.com

How about this to start:

Dim mcountunboundcontrol as Integer


if isnull(me.unboundcontrol) Then
mcountunboundcontrol = mboundcontrol + 1
etc - cycle through controls

End if

Bonnie

http://www.dataplus-svc.com
 
Top