I have a label that uses layers and there are conditions as to when a layer should print. But I am finding that maintaining the layers is becoming an issue. I would much rather have a VB Script in the "OnNewRecord" to control the visibility of the fields.
However a couple of the conditions use "contains" or "does not contain"... is there a vbfunction/operator that I can use? Does Bartender allow wildcards?
Basically I need to be able to say "If the field contains "*MTHS" or "* YRS" then make Text 22 visible. But if the field contains "*MONTHS" or "*YEARS" make Text 25 visible.
There are other conditions but those are definite ones....
Any help or guidance would be appreciated.
Fernando Ramos MiracleModerator
Please sign in to leave a comment.