Originally posted by spicouc
I've a big problem, i can't understand at all the VBA programming code.
I want to hide a lable in a report when in a textbox value ies Null or "", but i don't know how to do it... I'm messed!
if textbox.text="" then
Another problem is that I don't undestand the diference abaut use:
ME!anything!... and ME.ANYTHING....
yes i want to thing that i'm not very dummy but at this moment...
Please help me.
if TRIM(textbox.text) = "" Then
label.visible = false
The TRIM is used to eliminate all the blanks in a string, because sometimes it's possible you think a textbox is empty, but it still contains spaces.
As far as I know about the ME!anything!... and ME.ANYTHING....
-stuff is that you usually use a point in VB-code when you refer to a variable.
On the other hand the exclamationmark (!) is used when referring to an object on a form.
Dim strParameter as String
Private Sub Form_Load()
Me.strParameter = "Hello"
Me ! textbox.caption = Me.strParameter