Hiding 2 Objects Based On A Access Database Field Follow
Currently using Bartender 9.01 and need some help with it's VBA, unfortunately i'm not really familiar with BT VBA
I'm trying to write a VBA script that instructs bartender to not print 2 fields based on another value of a field, which effectively grabs the data from an access database
anyhow, at this time i keep getting a Line 6 Type Mismatch: 'Object' error message
'Automatically called whenever the value of the Sub String is needed. 'Set the Value property to set the value of this sub string. If Field("NoBestBefore") = "1" Then Value = "" Object("Text 17").PrintVisibility = False Else If IsNumeric(BBOffset) Then Value = DateAdd("d",BBOffset,DateAdd("d",0,PackedDate)) Else Value = "Error" Object("Text 17").PrintVisibility = False End if End If
Please sign in to leave a comment.