b4bis91
02-16-2019, 05:41 PM
Hi all,
This site has been a great resource but, this time around, I was not able to find a solution. On my form, I have I have a label, and I am trying to incorporate a calculation in it. I want it to say "Units: x", where x is a number that is calculated.
UnitsLabel.Caption = "Units " & CStr(ColNumb * RowNumb)
But I can only make it work if I take out the colon. What can I do to keep the colon. here is what I've tried.
UnitsLabel.Caption = "Units: " & CStr(ColNumb * RowNumb)
And this only returned the label as "Units:" The numbers would disappear. I tried this:
UnitsLabel.Caption = "Units" & CStr(": ") & CStr(ColNumb * RowNumb)
I hope I've provided all of the detail. Thank you in advance.
This site has been a great resource but, this time around, I was not able to find a solution. On my form, I have I have a label, and I am trying to incorporate a calculation in it. I want it to say "Units: x", where x is a number that is calculated.
UnitsLabel.Caption = "Units " & CStr(ColNumb * RowNumb)
But I can only make it work if I take out the colon. What can I do to keep the colon. here is what I've tried.
UnitsLabel.Caption = "Units: " & CStr(ColNumb * RowNumb)
And this only returned the label as "Units:" The numbers would disappear. I tried this:
UnitsLabel.Caption = "Units" & CStr(": ") & CStr(ColNumb * RowNumb)
I hope I've provided all of the detail. Thank you in advance.