How To Automaticaly Control The Color Of A Text From An Access Field 关注

0
Avatar
Legacy Poster

Good morning,

I am new in this forum (and a new bartender user too), so sorry in advance if this topic has been already made but I didn't find it.

 

I have the text of my labels in bartender from an Office Access 2007 data base.

In one field, I have the color in wich one I would like to print the text with baretender.

 

How can I do to use this field in bartender in order to print the text in the correct color. The color can change at each label.

 

Thanks for your consideration.

3 评论
0
Avatar
Shotaro Ito
评论操作 固定链接

BarTender Automation edition (Ver 9.3 or later) has such function, though you need some VB Script.

this topic might helps:

http://forums.seagullscientific.com/index.php?/topic/213-how-to-change-object-properties/

0
Avatar
Legacy Poster
评论操作 固定链接

Thank you for your answer.

I will study that.

0
Avatar
Legacy Poster
评论操作 固定链接

I put this :

 

Set Texte = Objects(Field("Etiquettes.Nom_produit"))
If (Field("Etiquettes.Couleur")) = “Red”) Then
      Texte.TextColor = btColor.Red
Else
      Texte.TextColor = btColor.Green
End If

 

But I have a script error message.

 

I am not too much familiar with VBscript .....

请先登录再写评论。