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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count unbonded text control that are not null 7
Complex Count Query 0
formating an unbound text box 1
looping thru controls 6
Disable/Enable all controls on a form based on value of anothercontrol 3
Unbound controls to create records 1
Passing the value of ActiveControl to Unbound Text Box 1
You must use the dbSeeChanges option with Open Recordset whenaccessing a SQL Server table that has a 1

Top