Vb Script To Change The Font Follow

0
Avatar
Legacy Poster

Hi all , new to Bartender, my issue is I have 10 character prod ID and need to have it display in this from :
Data from database :1234567890
Data to be printed : 123-4567-890 and in addtion the 3456 need to be bold and in larger font say 14 and the rest (the first 3 and last 3 character in 10)

I modified the sample script to this :

Value =left(value,3)+"-"+mid(Value,3,4)+"-"+right(value,3)

but I have no idea s to how I can make the font change in the middle

Thank you in advance for those who help, appreciated.

2 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

Create your text object so that it has five data sources. The data sources will be a mix of the same data base field and embedded static data that contains the dash. For each database filed data source you should use the transforms tab to keep/truncate those parts of the field data that you do not need for that data source.

This is how your data sources should be defined:

Database field (Keep first 3 digits)
Embedded data "-"
Database field (Truncate first and last 3 digits)
Embedded data "-"
Database field (Keep last 3 digits)
0
Avatar
Legacy Poster
Comment actions Permalink

[quote name='Ian C - Seagull Support' timestamp='1349258638' post='3388']
Create your text object so that it has five data sources. The data sources will be a mix of the same data base field and embedded static data that contains the dash. For each database filed data source you should use the transforms tab to keep/truncate those parts of the field data that you do not need for that data source.

This is how your data sources should be defined:

Database field (Keep first 3 digits)
Embedded data "-"
Database field (Truncate first and last 3 digits)
Embedded data "-"
Database field (Keep last 3 digits)
[/quote]

If you create separate data sources like Ian C suggests, you can change the font per data source by clicking 'font' then 'font per data source'.

[attachment=316:Font.jpg]

Please sign in to leave a comment.