Hi, Good day. I have a single form that includes a number of text boxes. How can I get the number of labels that the it's text is null ?
Sent from my SM-J701F using Tapatalk
Hi, Good day. I have a single form that includes a number of text boxes. How can I get the number of labels that the it's text is null ?
Sent from my SM-J701F using Tapatalk
Please restate your issue another way.
Therein lies an example of auto correct when using a phone, I'd say. I think the count relates to textboxes that don't have any data in them because a label cannot be blank AFAIK. But why ask for a count of labels rather than a count of those textboxes?? Regardless, to get a count of those labels means the labels would have to be attached to/associated with those textboxes. If they're not attached, difficult if not impossible.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Yes, of course, right, how do I calculate the number of labels whose text boxes are nulls?Therein lies an example of auto correct when using a phone, I'd say. I think the count relates to textboxes that don't have any data in them because a label cannot be blank AFAIK. But why ask for a count of labels rather than a count of those textboxes?? Regardless, to get a count of those labels means the labels would have to be attached to/associated with those textboxes. If they're not attached, difficult if not impossible.
Sent from my SM-J701F using Tapatalk
Why wouldn't the number of labels = the number of textboxes?
Last edited by davegri; 05-18-2019 at 12:30 PM. Reason: sp
Untested, but something like
I have no idea what you want to do with the calculation or what you're going to use to call the code that would perform it. Thus I didn't provide a name for the procedure code I posted and nothing more than a message box to report the count.Code:Dim ctl As Control Din n As Integer For each ctl in Me.Controls If ctl.ControlType = acTextbox And Nz(ctl,"") = "" Then n = n + 1 Next Msgbox n
I will use your code. I'll explain. The form is in single mode and includes textboxes in the number of machines in the workshops, each labeled with each txtbox or code of each device. The operator information and the number of devices produced from different tables are obtained. I'm going to get the statistics and graphs of the devices that have their colors distinct and to apply them in subsequent analyzes.Untested, but something like
I have no idea what you want to do with the calculation or what you're going to use to call the code that would perform it. Thus I didn't provide a name for the procedure code I posted and nothing more than a message box to report the count.Code:Dim ctl As Control Din n As Integer For each ctl in Me.Controls If ctl.ControlType = acTextbox And Nz(ctl,"") = "" Then n = n + 1 Next Msgbox n
Sent from my SM-J701F using Tapatalk
Sorry if my English language is not good. and sometimes I do not understand what you mean. But I will use your code and I will be glad if you still help me in the future
Sent from my SM-J701F using Tapatalk
Sorry if my English language is not good. and sometimes I do not understand what you mean. But I will use your code and I will be glad if you still help me in the future
Sent from my SM-J701F using Tapatalk
No apologies for that are necessary. The way I see it, anyone who can communicate in more than one language is more skilled than me. I suggest if you don't understand a question, seek clarification. It may help you if you use a web translator for things you don't understand. You could translate a question into your own language, which might help.Sorry if my English language is not good
Good luck.